Target Table Layout:
TARGET_DW_DB is an Oracle Data Warehouse database in KLXY Limited. Table STOCK_TRADING_FCT is mapped with the source tables NSE_TBL and BSE_TBL and linked with the LOOKUP tables. Data from NSE_TBL and BSE_TBL will be migrated to STOCK_TRADING_FCT on the last day of the month.
FACT Table: STOCK_TRADING_FCT
Stock Trading Identifier
STCK_TRD_ID
Surrogate Key
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Source Code
SRC_SYS_CD
FK to Source System Lookup
NSE
NSE
NSE
NSE
NSE
NSE
BSE
BSE
BSE
BSE
BSE
BSE
NSE
NSE
NSE
NSE
NSE
NSE
BSE
BSE
BSE
BSE
BSE
BSE
Company Code
CMPNY_CD
FK to Company Lookup
ABC
ABC
ABC
XYZ
XYZ
XYZ
ABC
ABC
ABC
XYZ
XYZ
XYZ
ABC
ABC
ABC
XYZ
XYZ
XYZ
ABC
ABC
ABC
XYZ
XYZ
XYZ
Date Identifier
DT_ID
Standalone Column
2
3
4
2
3
4
2
3
4
2
3
4
5
6
7
5
6
7
5
6
7
5
6
7
Previous Day Closing Price
PRVS_DY_CLS_PRC
Standalone Column
950.00
1025.00
1050.00
2950.00
3025.00
3050.00
974.00
999.15
1024.15
2999.00
2999.15
3024.15
1000.00
1075.00
1100.00
3000.00
3075.00
3100.00
1024.00
1049.15
1074.15
3049.00
3049.15
3074.15
Today Opening Price
TDY_OPN_PRC
Standalone Column
1000.00
1000.00
1075.00
3000.00
3000.00
3075.00
974.45
974.45
1049.45
2974.45
2974.45
3049.45
1050.00
1050.00
1125.00
3050.00
3050.00
3125.00
1024.45
1024.45
1099.45
3024.45
3024.45
3099.45
Today Highest Price
TDY_HGHST_PRC
Standalone Column
1020.00
1000.00
1100.00
3020.00
3000.00
3100.00
994.35
974.35
1074.35
2994.35
2974.35
3074.35
1070.00
1050.00
1150.00
3070.00
3050.00
3150.00
1044.35
1024.35
1124.35
3044.35
3024.35
3124.35
Today Lowest Price
TDY_LWST_PRC
Standalone Column
930.00
900.00
1050.00
2930.00
2900.00
3050.00
994.25
974.25
1074.25
2994.25
2974.25
3074.25
980.00
950.00
1100.00
2980.00
2950.00
3100.00
1044.25
1024.25
1124.25
3044.25
3024.25
3124.25
Last Traded Price
LST_TRD_PRC
Standalone Column
1025.00
1050.00
1150.00
3025.00
3050.00
3150.00
999.15
1024.15
1124.15
2999.15
3024.15
3124.15
1075.00
1100.00
1200.00
3075.00
3100.00
3200.00
1049.15
1074.15
1174.15
3049.15
3074.15
3174.15
Stock Traded Indicator
STCK_TRD_IND
Standalone Column
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
System Date
SYS_DT
Standalone Column
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
31-Mar-07
30-Apr-2007
30-Apr-2007
30-Apr-2007
30-Apr-2007
30-Apr-2007
30-Apr-2007
30-Apr-2007
30-Apr-2007
30-Apr-2007
30-Apr-2007
30-Apr-2007
30-Apr-2007
Note: Informatica and its related products are Trademarks of Informatica Corporation. For more details,
please visit their official website www.Informatica.com
