Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 6187 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
What is joiner transformation?
What are some examples of informatica etl programs?
How does the aggregator transformation handle null values?
what is index?how it can work in informatica
What is the way to execute pl/sql script using informatica mapping?
How might you approve all mappings in the archive all the while?
Why update strategy and union transformations are active? Explain with examples.
Difference between Target-based loading and constraint-based loading?
How can we handle two sessions in informatica?
What is fact table? Explain the different kinds of facts.
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?
How can informatica be used for an organization?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How you can differentiate between connected lookup and unconnected lookup?
In development project what is the process to follow for an etl developer from day1
