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]