how to connect two or more table with single source qualifier?

Question Posted / prasad.k

4 Answers
20798 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to connect two or more table with single source qualifier?..

Answer / sukanta

Drag two tables to mapping designer.Now with two tables two
source qualifier has come to the workspace among which you
delete second source's source qualifier.Now drag all ports
from 2nd source to first source qualifier.Now the first
qualifier have contained all ports of two sources.

But before than that in source analyzer you make a PK-FK
relation between two sources.Now in the source qualifier you
make a join condition upon that two port for PK-FK.

You get the solution.

Regards
Sukanta

Is This Answer Correct ?

18 Yes

1 No

how to connect two or more table with single source qualifier?..

Answer / tilak kumar dhar

We can use a Source Qualifier Transformation for this.

Perform the steps to achieve it:

1. Drag all the tables in Mapping Designer.
2. Delete all the source qualifiers associated with all the
tables.
3. Create a SQ transformation.
4. Drag all the columns from all the tables into the SQ
transformation.

Is This Answer Correct ?

5 Yes

1 No

how to connect two or more table with single source qualifier?..

Answer / kish

hi,

by using sql override....

Is This Answer Correct ?

3 Yes

1 No

how to connect two or more table with single source qualifier?..

Answer / rampriya

Create a Oracle source with how much ever column you want
and write the join query in SQL query override. But the
column order and data type should be same as in the SQL query.

Is This Answer Correct ?

1 Yes

7 No

Post New Answer