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
- 7148 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Different types of Power center errors?
What is the difference between normal and bulk loading? Which one is recommended?
what is the necessity to use update strategy?(except for updates)
How to generate the HTML output using Informatica.
Is it possible to use a client with different version than that of its Informatica server?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
can we import source table without using source qualifier? if yes then how? if no then why?
How to configure mapping in informatica?
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
What are the different threads in DTM process?
Teradata 
