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
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is data movement mode in Informatica and difference between them?
What are the types of data warehouses?
Under what condition selecting sorted input in aggregator may fail the session?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
what is diff b/t sorter t/r and agg have the option sorter property...
Is it possible to use a client with different version than that of its Informatica server?
What is resilience time?
explain one complex mapping with logic? sales project?
Explain informatica architecture - version 8 / 9
What does update strategy mean, and what are the different option of it?
what is the -ve test case in your project.
What do think which one is the better joiner or look up?
Target increases every day even though no new record was inserted
What are mapplets? How is it different from a Reusable Transformation?