Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7223 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 song in infrmatica...?
How to create the source and target database connections in server manager?
Explain direct and indirect flat file loading (source file type) - informatica
What is depict expression change?
what are the Methods For Creating Reusable Transformations?
What are the transformations that are not supported in mapplet?
4 yrs etl devloper roles and responsibilities?any body give solutions
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How can we remove the duplicates from flat file source?
What is dimensional table? Explain the different dimensions.
What is sq transformation?
What is olap (on-line analytical processing?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is meant by lookup transformation? Explain the types of lookup transformation?
