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 |
Please let me know how to make Data masking in informatica..
what is the diff b/w union and joiner and lookup?
What is update override?
What is a grid in Informatica?
what are the transformations that restricts the partitioning of sessions?
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
what is the flat file partition and where have to specify it
What is union transformation?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
Sequence generator, when you move from develoment to production how will you reset
in realtime which situations u can use unconnected lookup transformation