Home » ETL - Informatica » Informatica Tutorial – Part 6

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

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>