Page    3 of 15       [ Previous ]  [ Next]



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 Company Code Previous Day Closing Price Today Opening Price Today Highest Price Today Lowest Price Last Traded Price System Date
TRNSCTN_DT CMPNY_CD PRVS_DY_CLS_PRC TDY_OPN_PRC TDY_HGHST_PRC TDY_LWST_PRC LST_TRD_PRC SYS_DT
Transaction_Date Script_Code Last_Day_Close Today_Open Today_High Today_Low Last_Traded_Price
23-Mar-07 ABCCORP 950 1000 1020 930 1025 23-Mar-07
24-Mar-07 ABCCORP 1025 1000 1000 900 1050 24-Mar-07
25-Mar-07 ABCCORP 1050 1075 1100 1050 1150 25-Mar-07
23-Mar-07 XYZPRIVATELIMITED 2950 3000 3020 2930 3025 23-Mar-07
24-Mar-07 XYZPRIVATELIMITED 3025 3000 3000 2900 3050 24-Mar-07
25-Mar-07 XYZPRIVATELIMITED 3050 3075 3100 3050 3150 25-Mar-07
23-Apr-07 ABCCORP 1000 1050 1070 980 1075 23-Apr-07
24-Apr-07 ABCCORP 1075 1050 1050 950 1100 24-Apr-07
25-Apr-07 ABCCORP 1100 1125 1150 1100 1200 25-Apr-07
23-Apr-07 XYZPRIVATELIMITED 3000 3050 3070 2980 3075 23-Apr-07
24-Apr-07 XYZPRIVATELIMITED 3075 3050 3050 2950 3100 24-Apr-07
25-Apr-07 XYZPRIVATELIMITED 3100 3125 3150 3100 3200 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


Page    3 of 15       [ Previous ]  [ Next]