what is left outer join?

Answer Posted / mahi

It will take all the records form detailed table,
and matching records form master table.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Quickly characterize reusable change?

693


Can informatica load heterogeneous targets from heterogeneous sources?

697


What is powercenter on grid?

697


What do you mean incremental aggregation?

623


What is the function of union transformation?

619






What is an expression transformation?

594


What are the steps involved in the migration from older version to newer version of Informatica Server?

1585


How would you join a node to the already existing domain?

683


What is an unconnected transformation?

667


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1035


Where do we use mapping variables in informatica?

618


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1018


What is a standalone command task?

656


How can one identify whether mapping is correct or not without connecting session?

883


What is session task and command task?

649