Home » ETL - Informatica » Informatica Tutorial – Part 7

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

Leave a Reply

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

*
*