what is left outer join?
Answers were Sorted based on User's Feedback
Answer / mahi
It will take all the records form detailed table,
and matching records form master table.
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / jay
For eg.
Select M.*, D.* from
Master M LEFT OUTER JOIN Details D
on M.ID = D.ID
In the above query we get all the records from Master table and matching records from Detail table.
In simple it takes all rows from the table which is left of the join and matching records from table which is in other side of the join.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rashid equbal
It will take all the records form detailed table,
and matching records from master table.
Is This Answer Correct ? | 0 Yes | 0 No |
tell me 5 session failure in real time how can you solve that in your project?
What happens if the info. Server doesn't find the session parameter in the parameter file?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
How does a rank transform differ from aggregator transform functions max and min?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
What is meant by pre and post session shell command?
How do you load only null records into target? Explain through mapping flow.
 Informatica Checkpoints
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
How to delete first 3 rows & last 3 rows in target table in informatica