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

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

More Informatica Interview Questions

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  


write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,


Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  


what happens when a batch fails?

3 Answers  






what is surrogate id ?

3 Answers   IBM,


What are the reusable transformations?

0 Answers   Informatica,


please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,


How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,


What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  


can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,


Categories