On lookup on any table we can get only a)any value or b)last
value but if i need both duplicate values How can i achieve?
Answer Posted / suresh
actually on lookup two ways we can put the values normally
we put a anyvalue(if you want to both duplicate values).
when we use SCD type 2 its must and should put on last value
into the look up Bcoz it should store the history.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How can we delete duplicate rows from flat files?
While migrating the data from one environment to another environment how would you manage the connections?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the various types of transformation?
Describe an informatica powercenter?
During the running session, output files are created by informatica server. Enlist few of them.
Explain the types of transformations?
What is a passive transformation?
What is a difference between complete, stop and abort?
Can you generate sequence numbers without using the sequence generator transformation?
Performance tuning in UNIX for informatica mappings?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is lookup transformation?
What is the need of etl tools?
How to extract sap data using informatica?