Lookup Table 3: MONTH_LKP
Month Identifier
MTH_ID
Primay Key
1
2
3
4
5
6
7
8
9
10
11
12
Month Description
MTH_DESC
Standalone Column
January
February
March
April
May
June
July
August
September
October
November
December
System Date
SYS_DT
Standalone Column
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
Lookup Table 4: DATE_LKP
Date Identifier
DT_ID
Primay Key
1
2
3
4
5
6
7
Month Identifier
MTH_ID
Foreign Key (FK)
1
3
3
3
4
4
4
Date Value
DT_VAL
Standalone Column
15-Jan-2007
23-Mar-2007
24-Mar-2007
25-Mar-2007
23-Apr-2007
24-Apr-2007
25-Apr-2007
System Date
SYS_DT
Standalone Column
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
01-Jan-2007
Note: Informatica and its related products are Trademarks of Informatica Corporation. For more details,
please visit their official website www.Informatica.com
