Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sandhya
detail outer is correct--keeps all the rows from master and
only matching rows from detail.for confirmation see join
types in joiner transformation designer guide
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
Enterprise data warehouse your projects phase by phase explain?
can we override a native sql query within informatica? How do we do it?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What all are steps in up gradation of Informatica server?
r u done any partitions in ur project?
which one is better performance wise joiner or look up
How many numbers of sessions can one group in batches?
How to differentiate between the active and passive transformations?
How to load last n records of file into target table - informatica
What are the new features of Power Center 5.0?
Write the unconnected lookup syntax and how to return more than one column.
When do you use sql override in a lookup transformation?
What are the transformations that are not supported in mapplet?
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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
