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
- 5968 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is Data Caches size?
Explain the difference between a data warehouse and a data mart?
lookup transformation with screenshots
Can we override a native sql query within informatica?
What are the different types of repositories created using informatica?
where to store informatica rejected data? How to extract the informatica rejected data?
Where do we use mapping variables in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is the cumulative sum and moving sum?
What is enterprise data warehousing?
Differentiate between reusable transformation and mapplet.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
what is $$$$?
What is Index Caches size?
How to start a workflow using pmcmd command?
