Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 6290 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sehaj
INNERJOIN-GIVES THAT RECORDS THAT ARE PRESENT IN BOTH THE TABLE
OUTERJOIN-GIVES THAT RECORDS WHICH ARE PRESENT AND ALSO
WHICH ARE NOT PRESENT IN ONE OF THE TABLE.
INEERJOIN-REQUIRES LESS PROCCESING TIME.
OUTERJOIN-REQUIRES THE MAX PROCESSING TIME AMONG ALL THE
KIND O JOINS.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
explan ur project architecture?
What is a transaction control transformation?
Explain joiner transformation in informatica
What do you understand by term role-playing dimension?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is workflow monitor?
What is primary and backup node?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
design of staging area?
Why is sorter an active transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Briefly explain the aggregator transformation?
What is main use of mapplet?
Explain lookup transformation in informatica
