what is left outer join?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to use a client with different version than that of its Informatica server?

645


how many types of dimensions are available in informatica?

564


How do you load only null records into target?

742


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

1690


explain one complex mapping with logic? sales project?

6154






which one is better performance wise joiner or look up

629


What is domain and gateway node?

699


How do you load first and last records into target table?

667


How can you generate reports in informatica?

581


Explain sql transformation in script mode examples in informatica

605


What all join we can perform in LOOKUP transformation?

569


Do you find any difficulty while working with flat files as source and target?

677


What is a grid in Informatica?

613


Parameter and variable differences

1615


What are the types of caches in lookup?

572