How many joins in Informatica

Answer Posted / srinivas

there are four types of joins in Informatica
1) Normal join
2) Master join
3) Detail join
4) Full outer join

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the types of lookup transformation?

585


How might one distinguish in the case of mapping is right or not without associating session?

648


What is a filter transformation and why it is an active one?

572


How you know when to use a static cache and dynamic cache in lookup transformation?

1349


In which transformation you cannot drag ports into it?

802






Where are the source flat files kept before running the session?

635


What are the databases that informatica can connect to windows?

595


How can you define user defied event?

636


How can we store previous session logs?

580


Under what condition selecting sorted input in aggregator may fail the session?

677


server hot-ws270 is connect to Repository B. What does it mean?

1869


Write the different tools in the workflow manager?

583


What is the Rank index port in Rank transformation?

678


scenario where i can use only concurrent execution of workflow.

2562


can anyone explain me about retail domain project in informatica?

7447