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?
Answers were Sorted based on User's Feedback
Answer / pradeep
We wil go for left outer join on the lookup table in the
source qualifier sql override so that it wil return both the
records.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What will be the approach?
How does a rank transform differ from aggregator transform functions max and min?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
How do you create single lookup transformation using multiple tables?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Why we select the table which has minimum number of records as Master table in joiner?
what is fact and what types of fact tables is there
How to handle changing source file counts in a mapping?
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
What does cheating measurement mean?