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
What is a filter transformation?
In informatica workflow manager, how many repositories can be created?
Informatica settings are available in which file?
Parameter and variable differences
In informatics server which files are created during the session rums?
How to do the error handling of if ur source is flatfiles?
What happens when a session fails and you click on recover?
In how many ways we can create ports?
Which is the t/r that builts only single cache memory?
How to load the data from a flat file into the target where the source flat file name changes daily?
Where is metadata stored?
What is a difference between complete, stop and abort?
How can we store previous session logs?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is a sequence generator transformation?