Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 7226 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to partition the Session?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How can informatica be used for an organization?
What are the guidelines to be followed while using union transformation?
How can we improve session performance in aggregator transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Does an informatica transformation support only aggregate expressions?
What are the new features of Power Center 5.0?
how to load dimension table and fact table. plz tell me the steps.
Explain the features of connected and unconnected lookup.
How can we use mapping variables in informatica? Where do we use them?
What is the meaning of decode in informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the performance considerations when working with aggregator transformation?
