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 the Default Source Option For Update Strategy Transformation?
How to start a workflow using pmcmd command?
What do you mean incremental aggregation?
What are the new features of informatica 9.x in developer level?
What is a mapplet/worklet in informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How can you define user defied event?
What are the new features of informatica 9.x at the developer level?
Separate from an archive server and a powerhouse?
What is union transformation in informatica?
Explain dynamic target flat file name generation in informatica
What are the settings that you use to configure the joiner transformation?
What are multi-group transformations?
What is meant by pre and post session shell command?
Parameter and variable differences