hi,frnds.can anyone tell me abt lookup tranformation in informatica.with realtime example.pls.
sreenidhi

Hi,

Lookup transformation points any one of the table. It may be relational table or flat file. Other transformations points the column of any table.

Using lookup transformation, we can transverse or search the value in the particular table.

Please get back to me in case of queries.

Thanks & Regardsm
Prakash Chandran

sanghala - Back in action

Friend,

What prakash jotted odwn was very nice and good explanation.

Adding to that -
It is the most imporatnt and powerful transforamtion thru which you can keep a track of your historical information, to update the info, etc..,

How ??

Suppose a Boy travelled in a airline when he was at the age of 10, and this airlines was maintaining the data warehouse with the passenger info.
Suppose after some years, again the boy(now a teenager) has taken a round on the same airlines.

Previous say this boy was staying in Florida and now as a teenager he is living in St.louis. Based on his historical passenger information, the recent info will be updated/tracked in a new way and the historical info will be remain in the same way.

The above is an example for Slowly changing dimensions in which we will use lookup trnasformation in most of the circumstances...

If you need any more info - Just give a personal message....

Hope this helps friend,

regards,
Data Warehousing Community Forum

__________________
Sanghala
www.dwforum.net - A Great resource for Data Warehousing Professionals

If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.

Actullay lookup is passive, connected and unconnected transformaion. With the help of lookup transformation we can avoid more source table and source qualifier transformation.

I think Bank transaction also a real time example for using the lookup transformation. if it is worng means sorry..

Lookup transformation is used to looking up the relational tables,flat files ,views,synonyms.Mainly lookup is used in creating fact table.
ex:
while loading fact table , take the transaction table and take the dimension table as lookup and give the condition in lookup for to check whether that transaction table having related data (information) and load that data to fact table.
Regards
Amaran