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.
|
Friday, 21 March 2014
What is the difference between source qualifier and Joiner?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment