Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect two or more table with single source qualifier?
- 4 Answers
- 21065 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sukanta
Drag two tables to mapping designer.Now with two tables two
source qualifier has come to the workspace among which you
delete second source's source qualifier.Now drag all ports
from 2nd source to first source qualifier.Now the first
qualifier have contained all ports of two sources.
But before than that in source analyzer you make a PK-FK
relation between two sources.Now in the source qualifier you
make a join condition upon that two port for PK-FK.
You get the solution.
Regards
Sukanta
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
How union transformation is used?
What is the sequence generator transformation in informatica?
What is the difference between informatica 7.0 and 8.0?
What is a snowflake schema?
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
What is informatica powercenter repository?
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
What are ETL Tools?
What does reusable transformation mean?
How to create the source and target database connections in server manager?
What is lookup change?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the different transaction levels available in transaction control transformation?
What you know about transaction control transformation?
What is difference between a gateway node and worker node?
