Interested to Buy Any Domain ? << Click Here >> for more details...
Why use the lookup transformation ?
- 2 Answers
- 6778 Views
- Informatica, I also Faced
- E-Mail Answers
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 |
Explain what are the different versions of informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
How can we get multiple output values using an unconnected lookup transformation?
what is mean by throghput? in informatica
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
Can we use the mapping parameters or variables created in one mapping into another mapping?
What is the difference between stop and abort in informatica
Mention few advantages of router transformation over filter transformation.
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
Teradata 
