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
- 7264 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
When do you use sql override in a lookup transformation?
Define mapping and session?
Can you generate sequence numbers without using the sequence generator transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are mapplets?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Enlist the differences between database and data warehouse.
What is the difference between a connected look up and unconnected lookup?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain the shared cache and re-cache?
have u done any performance tuning? how u ll do?
On which transformations you created partitions in your project?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is repository manager?
