Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 6156 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
What is the cumulative sum and moving sum?
waht type of interface is used for testing the data in informatica
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Define Pmrep command?
Enlist the advantages of informatica.
How can we delete duplicate rows from flat files?
Is it possible to create multiple domains on a single Informatica server?
What is the Rank index port in Rank transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is a stored procedure transformation?
what is Active lock explain
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the types of caches in lookup?
What is the way to execute pl/sql script using informatica mapping?
