look up transformation can be used in a table view based on
condition by default lookup is left outer join
65) why use the lookup transformation?
To perform the following tasks.
Get a related value.For example if your table includes employee
ID,but you want to include 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.
66) what are the types of lookup?
Connected and unconnected
No comments:
Post a Comment