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 |
Parameter and variable differences
What is partioning?how many types of partinings are there
How can you differentiate between powercenter and power map?
what r the values tht r passed between informatics server and stored procedure?
How to generate sequence numbers without using the sequence generator transformation?
we have to use order by,where,having we to implement sql query
how many ways can we implement SCD2?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
Can you copy the session to a different folder or repository?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
Name the different lookup cache(s)?