|
|
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]
|
|
