Home » Archive by category "ETL – Informatica" (Page 2)

Informatica Tutorial – Part 8

ETL process using Informatica: So far we have explained about the source tables and how data need to be transformed before loading into target tables. In this section, we will see how this is implemented using Informatica. Quick Overview: Sources: National Stock Exchange (NSE) and...
Read More

Informatica Tutorial – Part 7

Target Table Layout: TARGET_DW_DB is an Oracle Data Warehouse database in KLXY Limited. Table STOCK_TRADING_FCT is mapped with the source tables NSE_TBL and BSE_TBL and linked with the LOOKUP tables. Data from NSE_TBL and BSE_TBL will be migrated to STOCK_TRADING_FCT on the last day of...
Read More

Informatica Tutorial – Part 6

Lookup Table 3: MONTH_LKP   Month Identifier MTH_ID Primay Key 1 2 3 4 5 6 7 8 9 10 11 12 Month Description MTH_DESC Standalone Column January February March April May June July August September October November December System Date SYS_DT Standalone Column 01-Jan-2007...
Read More

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...
Read More

Informatica Tutorial – Part 4

Table 2: BSE_TBL   Transaction Date TRNSCTN_DT Transaction_Date 23-Mar-07 24-Mar-07 25-Mar-07 23-Mar-07 24-Mar-07 25-Mar-07 23-Apr-07 24-Apr-07 25-Apr-07 23-Apr-07 24-Apr-07 25-Apr-07 Company Code CMPNY_CD Script_Code ABCCORP ABCCORP ABCCORP XYZPRIVATELIMITED XYZPRIVATELIMITED XYZPRIVATELIMITED ABCCORP ABCCORP ABCCORP XYZPRIVATELIMITED XYZPRIVATELIMITED XYZPRIVATELIMITED Previous Day Closing Price PRVS_DY_CLS_PRC Last_Day_Close 974 999.15 1024.15...
Read More

Informatica Tutorial – Part 3

Source Tables Layout and Data(Database Name – SOURCE_SILO_DB) Source data from the external sources NSE and BSE need to be migrated to two tables namely NSE_TBL & BSE_TBL contained within an Oracle database named SOURCE_SILO_DB. The column names are changed and there is no change...
Read More

Informatica Tutorial – Part 2

Data from the external sources (source1 – .CSV (comma seperated) file , source2 – Oracle table) : Assume that the data from NSE is in Oracle file format and the data from BSE is a Comma Separated .CSV File and these two files form the...
Read More

Meta