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
- 7151 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
Why sorter is an active transformation?
where to store informatica rejected data?
What is the difference between STOP and ABORT options in Workflow Monitor?
What could be the possible resons of locks by user?
what is mean by complex business rule ?
Explain the types of transformations?
What is workflow? What are the components of workflow manager?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
where to store informatica rejected data? How to extract the informatica rejected data?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the difference between Active and Passive transformation?
What does role playing dimension mean?
explan ur project architecture?
What are the different options available for update strategy?
What are the different types of repositories created using informatica?
