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 are 3 tech challenges/ common issues you face?
What is a filter transformation?
What is a pre-defined event and user-defined event?
What is the meaning of up gradation of repository?
Differentiate between sessions and batches?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How many number of sessions can one group in batches?
What do you mean by filter transformation?
What is incremental aggregation?
What is the function of aggregator transformation?
How to start a workflow using pmcmd command?
Define joiner transformation?
What do you mean by worklet?
What is decode in informatica?
How to partition the Session?