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
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
How to differentiate between the active and passive transformations?
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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to go to the older version for a mapping?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are the restrictions of union transformation?
What is incremental aggregation?
What are the new features of informatica 9.x developer?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain in detail about scd type 1 through mapping.
What is meant by incremental aggregation?
How identifying bottlenecks in various components of informatica and resolving them?
What is meant by a domain?
Repository user profiles