Informatica Tutorial – Part 2

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.

Source 1: Raw Data From NSE – .CSV (comma separated) file

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

Stock_Symbol

ABCCORP
ABCCORP
ABCCORP
XYZPRIVATELIMITED
XYZPRIVATELIMITED
XYZPRIVATELIMITED
ABCCORP
ABCCORP
ABCCORP
XYZPRIVATELIMITED
XYZPRIVATELIMITED
XYZPRIVATELIMITED

Previous_Day_Close

950
1025
1050
2950
3025
3050
1000
1075
1100
3000
3075
3100

Today_Open

1000
1000
1075
3000
3000
3075
1050
1050
1125
3050
3050
3125

Today_High

1020
1000
1100
3020
3000
3100
1070
1050
1150
3070
3050
3150

Today_Low

930
900
1050
2930
2900
3050
980
950
1100
2980
2950
3100

Last_Traded_Price

1025
1050
1150
3025
3050
3150
1075
1100
1200
3075
3100
3200

Source 2: Raw Data From BSE – Oracle Table

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

Script_Code

ABCCORP
ABCCORP
ABCCORP
XYZPRIVATELIMITED
XYZPRIVATELIMITED
XYZPRIVATELIMITED
ABCCORP
ABCCORP
ABCCORP
XYZPRIVATELIMITED
XYZPRIVATELIMITED
XYZPRIVATELIMITED

Last_Day_Close

974
999.15
1024.15
2999
2999.15
3024.15
1024
1049.15
1074.15
3049
3049.15
3074.15

Today_Open

974.450
974.45
1049.45
2974.45
2974.45
3049.45
1024.45
1024.45
1099.45
3024.45
3024.45
3099.45

Today_High

994.35
974.35
1074.35
2994.35
2974.35
3074.35
1044.35
1024.35
1124.35
3044.35
3024.35
3124.35

Today_Low

994.25
974.25
1074.25
2994.25
2974.25
3074.25
1044.25
1024.25
1124.25
3044.25
3024.25
3124.25

Last_Traded_Price

999.15
1024.15
1124.15
2999.15
3024.15
3124.15
1049.15
1074.15
1174.15
3049.15
3074.15
3174.15

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