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
