Why use the lookup transformation ?
Answers were Sorted based on User's Feedback
Answer / rekha
1. GET A REALTED VALUE
2.UPDATE SLOWLY CHANGING DIMENSION
3.PERFORM CALCULATIONS
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / swetha
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.
Is This Answer Correct ? | 0 Yes | 1 No |
What is best approach to load 100 different source files (Different structure) to differet target tables ?
How identifying bottlenecks in various components of informatica and resolving them?
What is a data modeling?
What are the new features of the server manager in the informatica 5.0?
can anyone suggest best free Talend data integration training online
What are Dimensions and various types of Dimensions?
why u go for dimensions ?
how will you get 21 to 30 record from 50 records?
Can anyone briefly describe abt audit table loading?
What is the difference between view and materialised view?
What is CDC? How to implement CDC?
What do you mean by filter transformation?