Friday, 21 March 2014

What is the difference between source qualifier and Joiner?

Source Qualifier
Joiner
We use source qualifier to join the tables  if tables are in the same database
We use joiner to join the tables  if tables are in the different  database
In source qualifier we can  use any type of join between two tables.
Where as in joiner we can’t use other than 4 types of joins.
We can join N number of sources in a single source qualifier using sq override
Where as in joiner we can join only 2 sources using 1 joiner, to join N sources we need N-1 joiners.

No comments:

Post a Comment