Home » ETL - Informatica » Informatica Tutorial – Part 4

Table 2: BSE_TBL

 

Transaction Date

TRNSCTN_DT

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

Company Code

CMPNY_CD

Script_Code

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

Previous Day Closing Price

PRVS_DY_CLS_PRC

Last_Day_Close

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

Today Opening Price

TDY_OPN_PRC

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 Highest Price

TDY_HGHST_PRC

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 Lowest Price

TDY_LWST_PRC

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

LST_TRD_PRC

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

System Date

SYS_DT

 

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

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

Leave a Reply

Your email address will not be published. Required fields are marked *