Lookup Tables:
Data from NSE_TBL and BSE_TBL are analyzed and the necessary lookup tables/fact tables are created. Here lookup tables include Source System Lookup, Company Lookup, Month Lookup, Date Lookup which are named SOURCE_SYSTEM_LKP, COMPANY_LKP, MONTH_LKP and DATE_LKP. The only fact table (i.e) Stock Trading Fact, named STOCK_TRADING_FCT is mapped with the source tables NSE_TBL and BSE_TBL and thereby linked with the LOOKUP tables.
To start with Static Data is loaded into the lookup tables and after validation/transformation, data is loaded into data warehouse fact table STOCK_TRADING_FCT. Lookup tables and Fact table are mentioned below.
Lookup Table 1: SOURCE_SYSTEM_LKP
Source System Code
SRC_SYS_CD
Primay Key
NSE
BSE
Source System Description
SRC_SYS_DESC
Standalone Column
National Stock Exchange
Bombay Stock Exchange
System Date
SYS_DT
Standalone Column
15-Jan-2007
15-Jan-2007
Lookup Table 2: COMPANY_LKP
Company Code
CMPNY_CD
Primay Key
ABC
XYZ
Company Description
CMPNY_DESC
Standalone Column
ABC Corporation
XYZ Private Limited
System Date
SYS_DT
Standalone Column
15-Jan-2007
15-Jan-2007
Note: Informatica and its related products are Trademarks of Informatica Corporation. For more details, please visit their official website www.Informatica.com.
