Answer Detail: RE: Why use the lookup transformation ?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

Question: Why use the lookup transformation ?

Answer: To perform the following tasks.
Get a related value. For example, if your source table includes employee ID, but you want to include the employee name in your target table to make your summary data easier to read.
Perform a calculation. Many normalized tables include values used in a calculation, such as gross sales per invoice or sales tax, but not the calculated value (such as net sales).
Update slowly changing dimension tables. You can use a Lookup transformation to determine whether records already exist in the target.

August 08, 2006 22:26:47	#1
samba	Member Since: Visitor Total Comments: N/A
RE: Why use the lookup transformation ?
Lookup table is nothing but the lookup on a table,view,synonym and falt file. by using lookup we can get a related value with join conditon and performs caluclations two types of lookups are there 1)connected 2)Unconnected connected lookup is with in pipeline only but unconnected lookup is not connected to pipeline unconneceted lookup returns single column value only let me know if you want to know any additions information cheers samba

Back To Question