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
- 7053 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 workflow monitor?
What is fact table? Explain the different kinds of facts.
What is a standalone command task?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to do the error handling of if ur source is flatfiles?
What are the advantages of informatica?
what is degenerated dimension?
What is meant by lookup transformation?
What is the command used to run a batch?
What is a surrogate key?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the session task and command task?
What are the components of Informatica? And what is the purpose of each?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Define sessions in informatica etl?
