how to connect two or more table with single source qualifier?

Answer Posted / rampriya

Create a Oracle source with how much ever column you want
and write the join query in SQL query override. But the
column order and data type should be same as in the SQL query.

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Under which circumstances, informatica server creates reject files?

830


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

727


How many transformations can be used in mapplets.

1670


Is it possible to create multiple domains on a single Informatica server?

1004


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

2015


What is the surrogate key?

852


How to update or delete the rows in a target, which do not have key fields?

898


Repository user profiles

1571


What is meant by lookup transformation?

801


Explain the types of lookup transformation?

778


What are the differences between a connected lookup and unconnected lookup?

833


How might one distinguish in the case of mapping is right or not without associating session?

850


How are indexes created after completing the load process?

1232


What is joiner change?

910


complex mapping ur project u r invlve can u explain and give real time example give me ?

2070