What is the look up transformation?

Use lookup transformation in u’r mapping to lookup data in a relational table,view,synonym.
Informatica server queries the look up table based on the lookup ports in the transformation.It compares the lookup transformation port values to lookup table column values based on the look up condition.

Showing Answers 1 - 7 of 7 Answers

phani

  • Dec 9th, 2005
 

Using it we can access the data from a relational table which is not a source in the mapping.

For Ex:Suppose the source contains only Empno, but we want Empname also in the mapping.Then instead of adding another tbl which contains Empname as a source ,we can Lkp the table and get the Empname in target.

  Was this answer useful?  Yes

a ETL guy

  • Dec 16th, 2005
 

A lookup is a simple, single-level reference structure with no parent/child relationships. Use a lookup when you have a set of reference members that you do not need to organize hierarchically.

  Was this answer useful?  Yes

an ETL guy

  • Dec 16th, 2005
 

In DecisionStream, a lookup is a simple, single-level reference structure with no parent/child relationships. Use a lookup when you have a set of reference members that you do not need to organize hierarchically.HTH

  Was this answer useful?  Yes

sithusithu

  • Jan 19th, 2006
 

Use a Lookup transformation in your mapping to look up data in a relational table, view, or synonym. Import a lookup definition from any relational database to which both the Informatica Client and Server can connect. You can use multiple Lookup transformations in a mapping.

Cheers,

Sithu

  Was this answer useful?  Yes

Sridhar Tirukovela

  • Jan 2nd, 2007
 

Lookup transformation in a mapping is used to look up data in a flat file or a relational table, view, or synonym. You can import a lookup definition from any flat file or relational database to which both the PowerCenter Client and Server can connect. You can use multiple Lookup transformations in a mapping.

I hope this would be helpful for you.

Cheers,

Sridhar

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions