when should one create lookup transformation ?
- 2 Answers
- 4609 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kaki
Look up transformation is used for looking up a value from
OLAP table within a mapping before populating it. For
example, I have empid and I want to get emp name to use in
the next transformation, I would search for it in a look up
table which has the emp name by giving input as emp id.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is a staging area? What is the purpose of a staging area?
how do u implement configuration management in Informatica?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
what is the difference steps for data modeling?
How can we use external procedural logic in informatica?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the production issues in datastage?
how do u implement unconn.stored proc. in a mapping?
what is session partitioning?
Teradata 
