Why use the lookup transformation ?

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.

  • Interview Candidate
  • 13
  • 2430

Showing Answers 1 - 13 of 13 Answers

samba

  • Aug 21st, 2006
 

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

  Was this answer useful?  Yes

Guest

  • Jan 5th, 2007
 

hey,  with regard to look up , is there a dynamic look up and static look up ? if so how do you set it. and is there a combinationation of dynamic connected lookups..and static unconnected look ups.?

  Was this answer useful?  Yes

Guest

  • Jan 9th, 2007
 

look up has two types ,Connected and Unconnected..Usually we use look-up so as to get the related Value from a table ..it has Input port ,Output Port ,Lookup Port and Return Port..where Lookup Port looks up the corresponding column for the value and resturn port returns the value..usually we use when there are no columns in common

  Was this answer useful?  Yes

binoop

  • Mar 22nd, 2007
 

For maintaining the slowly changing diamensions

  Was this answer useful?  Yes

vivek1708

  • May 8th, 2008
 

Hi

The ans to ur question is Yes
There are 2 types of lookups: Dynamic and Normal (which you have termed as Static).

To configure, just double click on the lookup transformation and go to properties tab
There'll be an option - dynamic lookup cache. select that...

If u dont select this option, then the lookup is merely a normal lookup.

Please let me know if there are any questions.

Thanks.

  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