Page    2 of 15       [ Previous ]  [ Next]




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 source data for our ETL operations throughout this tutorial. Following two Record Layouts, show the source data from NSE and BSE respectively.

Source1: Raw Data From NSE - .CSV (comma seperated) file

Date Stock_Symbol Previous_Day_Close Today_Open Today_High Today_Low Last_Traded_Price
23-Mar-07 ABCCORP 950 1000 1020 930 1025
24-Mar-07 ABCCORP 1025 1000 1000 900 1050
25-Mar-07 ABCCORP 1050 1075 1100 1050 1150
23-Mar-07 XYZPRIVATELIMITED 2950 3000 3020 2930 3025
24-Mar-07 XYZPRIVATELIMITED 3025 3000 3000 2900 3050
25-Mar-07 XYZPRIVATELIMITED 3050 3075 3100 3050 3150
23-Apr-07 ABCCORP 1000 1050 1070 980 1075
24-Apr-07 ABCCORP 1075 1050 1050 950 1100
25-Apr-07 ABCCORP 1100 1125 1150 1100 1200
23-Apr-07 XYZPRIVATELIMITED 3000 3050 3070 2980 3075
24-Apr-07 XYZPRIVATELIMITED 3075 3050 3050 2950 3100
25-Apr-07 XYZPRIVATELIMITED 3100 3125 3150 3100 3200



Source2: Raw Data From BSE - Oracle Table

Transaction_Date Script_Code Last_Day_Close Today_Open Today_High Today_Low Last_Traded_Price
23-Mar-07 ABCCORP 974 974.450 994.35 994.25 999.15
24-Mar-07 ABCCORP 999.15 974.45 974.35 974.25 1024.15
25-Mar-07 ABCCORP 1024.15 1049.45 1074.35 1074.25 1124.15
23-Mar-07 XYZPRIVATELIMITED 2999 2974.45 2994.35 2994.25 2999.15
24-Mar-07 XYZPRIVATELIMITED 2999.15 2974.45 2974.35 2974.25 3024.15
25-Mar-07 XYZPRIVATELIMITED 3024.15 3049.45 3074.35 3074.25 3124.15
23-Apr-07 ABCCORP 1024 1024.45 1044.35 1044.25 1049.15
24-Apr-07 ABCCORP 1049.15 1024.45 1024.35 1024.25 1074.15
25-Apr-07 ABCCORP 1074.15 1099.45 1124.35 1124.25 1174.15
23-Apr-07 XYZPRIVATELIMITED 3049 3024.45 3044.35 3044.25 3049.15
24-Apr-07 XYZPRIVATELIMITED 3049.15 3024.45 3024.35 3024.25 3074.15
25-Apr-07 XYZPRIVATELIMITED 3074.15 3099.45 3124.35 3124.25 3174.15


Note: Informatica and its related products are Trademarks of Informatica Corporation. For more details, please visit their official website www.Informatica.com




Page    2 of 15       [ Previous ]  [ Next]