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

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1922


How to differentiate between the active and passive transformations?

859


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1932


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1858


How to go to the older version for a mapping?

829


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1049


What are the restrictions of union transformation?

823


What is incremental aggregation?

834


What are the new features of informatica 9.x developer?

755


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

865


Explain in detail about scd type 1 through mapping.

852


What is meant by incremental aggregation?

781


How identifying bottlenecks in various components of informatica and resolving them?

871


What is meant by a domain?

870


Repository user profiles

1583