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?
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
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is Data Caches size?
what is degenerated dimension?
What are the features of complex mapping?
What are data-driven sessions?
Write the prerequisite tasks to achieve the session partition?
What are the modules in Power Center
what is the size of u r source(like file or table)?
Why do you use Mapping Parameter and mapping variable?
What is rank transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
Name the different lookup cache(s)?
What is the difference between informatics 7x and 8x and what is latest version?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Mention few advantages of router transformation over filter transformation.