Page 1     2     3     4     5     6     7     8     9     10



Second Step: Creating Target(Staging) Database(TARGET_DW_DB)

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 Source System Description System Date
SRC_SYS_CD SRC_SYS_DESC SYS_DT
Primay Key Standalone Column Standalone Column
NSE National Stock Exchange 15-Jan-2007
BSE Bombay Stock Exchange 15-Jan-2007


Lookup Table 2: COMPANY_LKP
Company Code Company Description System Date
CMPNY_CD CMPNY_DESC SYS_DT
Primay Key Standalone Column Standalone Column
ABC ABC Corporation 15-Jan-2007
XYZ XYZ Private Limited 15-Jan-2007

[ Previous ] [ Continue to Next Page ... ]



Page 1     2     3     4     5     6     7     8     9     10