Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 5262 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar
INNER JOIN MEANS, IF THE JOIN CONDITION SATISFIES THEN ONLY
BOTH TABLE RECORDS ARE JOINED OTHERWISE REJECTED.
IF THE JOIN TYPE IS OUTER JOIN MEANS THERE IS JOINED THE
RECORDS WITH MATCHING AND NON MATCHING RECORDS.
if it wrong means please mail me chandranmca2007@gmail.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain sessions?
What is the function of union transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Explain load alternative records / rows into multiple targets - informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are junk dimensions?
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain direct and indirect flat file loading (source file type) - informatica
What is meant by LDAP users?
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 does role playing dimension mean?
whats the logic to load the lower level of granularity of data to fact table.
Explain dynamic target flat file name generation in informatica
What is pmcmd command?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
