Can anyone please distinguish what is Inner join and Outer join
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 transaction control transformation in informatica
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 union transformation is used?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Where is metadata stored?
What are the informatica performance improvement tips
What is the meaning of decode in informatica?
How many types of sessions are there in informatica.please explain them?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
can we override a native sql query within informatica? How do we do it?
tell me about your project functionality
What do you mean by enterprise data warehousing?
whats the logic to load the lower level of granularity of data to fact table.
Which means the first record should come as last record and last record should come as first record and load into the target file?