Home » ETL - Informatica » 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 in the actual data. Please refer to the Table 1 & Table 2 for NSE_TBL and BSE_TBL data.

Table 1: NSE_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

950
1025
1050
2950
3025
3050
1000
1075
1100
3000
3075
3100

Today Opening Price

TDY_OPN_PRC

Today_Open

1000
1000
1075
3000
3000
3075
1050
1050
1125
3050
3050
3125

Today Highest Price

TDY_HGHST_PRC

Today_High

1020
1000
1100
3020
3000
3100
1070
1050
1150
3070
3050
3150

Today Lowest Price

TDY_LWST_PRC

Today_Low

930
900
1050
2930
2900
3050
980
950
1100
2980
2950
3100

Today Lowest Price

LST_TRD_PRC

Last_Traded_Price

1025
1050
1150
3025
3050
3150
1075
1100
1200
3075
3100
3200

System Date

SYS_DT

 

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

 

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>