Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 5237 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
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is InformaticaPowerCenter?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is a router transformation?
When do you use sql override in a lookup transformation?
Briefly explain the aggregator transformation?
What are the databases that informatica can connect to windows?
Could you explain what is enterprise data warehouse?
What is Index Caches size?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
whats the logic to load the lower level of granularity of data to fact table.
Explain what transformation and how many are there in informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How can you differentiate between powercenter and power map?
What is the difference between writing a joiner query in ANSI style and THETA style?
