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