Home » ETL - Informatica » Informatica Tutorial – Part 5

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>