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


Please Help Members By Posting Answers For Below Questions

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1352


What is Data Caches size?

836


what is degenerated dimension?

3514


What are the features of complex mapping?

871


What are data-driven sessions?

952


Write the prerequisite tasks to achieve the session partition?

848


What are the modules in Power Center

1430


what is the size of u r source(like file or table)?

2017


Why do you use Mapping Parameter and mapping variable?

1482


What is rank transformation?

761


What is meant by lookup transformation? Explain the types of lookup transformation?

747


Name the different lookup cache(s)?

935


What is the difference between informatics 7x and 8x and what is latest version?

801


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1683


Mention few advantages of router transformation over filter transformation.

835