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?
- 3 Answers
- 6223 Views
- I also Faced
- E-Mail Answers
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 |
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
Performance wise which is better joiner or look up ? Give me with example?
Explian the Process of deployment groups in informatica
What is a surrogate key?
What is limitations of truncate and load option
what is the incremental agrrigation?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
How many mapplets u have created? and what is the logic used
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
Reusable transformation and shortcut differences
Can you access a repository created in previous version of Informatica?
how can one come to know wether the records loak into the target if we use update strategy
Teradata 
