WHat all joins are there in Source Qualifier?

Answer Posted / pr

The default join is inner join. But we can override it by using the SQL overide query and can perform any joins

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does update strategy mean, and what are the different option of it?

696


How to create a non-reusable instance of reusable transformations?

784


What is the use of an aggregator cache file?

778


What is a shortcut and copy in Informatica and how two are different with each other?

788


In which transformation you cannot drag ports into it?

910






How many types of sessions are there in informatica.please explain them?

776


Please let me know how to make encryption and decryption with example?

1571


Explian the Process of deployment groups in informatica

730


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

766


design of staging area?

1695


What is informatica? Why do we need it?

743


How we can use union transformation?

696


What is a difference between complete, stop and abort?

740


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6640


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

1162