Answer Detail: RE: Why we use lookup transformations?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

Question: Why we use lookup transformations?

Answer: Lookup Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks:

Get a related value-Get the Employee Name from Employee table based on the Employee IDPerform Calculation.

Update slowly changing dimension tables - We can use unconnected lookup transformation to determine whether the records already exist in the target or not.

January 01, 2006 01:12:33	#1
Sithu	Database Expert Member Since: December 2005 Total Comments: 161
RE: Why we use lookup transformations?
Nice Question, If we don't have a look our datawarehouse will be have more unwanted duplicates 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

Back To Question