If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
Answer / gurpreet singh
Normal Join - All matching rows of A and B
Master Outer join - All rows of detail including matching
rows from master
Detail Outer join - All rows of Master including matching
rows from detail.
Full outer join - All rows from Master and detail table
including matching rows.
Is This Answer Correct ? | 14 Yes | 0 No |
Define filter transformation?
waht type of interface is used for testing the data in informatica
how did u understand business requirement?
wf dont have integration severances how you can run?
HOW TO YOU LOAD TIME DIMENSION
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What are the challenges you have faced in your project?
List the transformation in informatica.
what are the limitations of pushdown optimization technique ? Advance thanks
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
How do you do error handling in Informatica?