|
|
Page 6 of 15
[ Previous ] [ Next]
Lookup Table 3: MONTH_LKP
| Month Identifier |
Month Description |
System Date |
| MTH_ID |
MTH_DESC |
SYS_DT |
| Primay Key |
Standalone Column |
Standalone Column |
| 1 |
January |
01-Jan-2007 |
| 2 |
February |
01-Jan-2007 |
| 3 |
March |
01-Jan-2007 |
| 4 |
April |
01-Jan-2007 |
| 5 |
May |
01-Jan-2007 |
| 6 |
June |
01-Jan-2007 |
| 7 |
July |
01-Jan-2007 |
| 8 |
August |
01-Jan-2007 |
| 9 |
September |
01-Jan-2007 |
| 10 |
October |
01-Jan-2007 |
| 11 |
November |
01-Jan-2007 |
| 12 |
December |
01-Jan-2007 |
Lookup Table 4: DATE_LKP
| Date Identifier |
Month Identifier |
Date Value |
System Date |
| DT_ID |
MTH_ID |
DT_VAL |
SYS_DT |
| Primay Key |
Foreign Key (FK) |
Standalone Column |
Standalone Column |
| 1 |
1 |
15-Jan-2007 |
01-Jan-2007 |
| 2 |
3 |
23-Mar-2007 |
01-Jan-2007 |
| 3 |
3 |
24-Mar-2007 |
01-Jan-2007 |
| 4 |
3 |
25-Mar-2007 |
01-Jan-2007 |
| 5 |
4 |
23-Apr-2007 |
01-Jan-2007 |
| 6 |
4 |
24-Apr-2007 |
01-Jan-2007 |
| 7 |
4 |
25-Apr-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
Page 6 of 15
[ Previous ] [ Next]
|
|
