how to join two tables without using joiner transformation .advantages of joine

Categories >> Software >> Data Warehouse >> ETL
Suggest New Category

how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.

Question Posted / jakki

5 Answers
14516 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to join two tables without using joiner transformation .advantages of joiner over lookup and vi..

Answer / abhishek kumar

using union transformation.........

Is This Answer Correct ?

3 Yes

1 No

how to join two tables without using joiner transformation .advantages of joiner over lookup and vi..

Answer / murthy

use oracle join in SQL override

Is This Answer Correct ?

4 Yes

3 No

how to join two tables without using joiner transformation .advantages of joiner over lookup and vi..

Answer / k bhavani durga

this can be used to join two sources coming from two
different locations or from the same locayion.for this
there mist be atleast one matching port and it is must to
specify one source as master and the other as detail.

it supports the following types of joins
1.normal
2.master outer
3.detail outer
4.full outer

Is This Answer Correct ?

2 Yes

2 No

how to join two tables without using joiner transformation .advantages of joiner over lookup and vi..

Answer / prasanna

Using lookup is equivalent to outer join on source table.
As Bhavani said, if you want to join 2 heterogeneous
sources you cannot join in SQ. Then you need to use join.

Ex: you have 2 sources. One is a table in a DB and another
is a faltfile then you can only join using joiner.

Adv: you can perform operations similar to inner, left
outer, right outer and full outer. But using a lookup its
equivalent to left outer join on source.

It's always better to join a table which is small in SQ
then creating a lookup on it for better performance

Is This Answer Correct ?

1 Yes

1 No

how to join two tables without using joiner transformation .advantages of joiner over lookup and vi..

Answer / k.rameshyadav

Lookup T/R is always is an alternate for joiner.
If the sources are same i.e homogenous we can perform join at database level.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer