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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

scenario where i can use only concurrent execution of workflow.

2528


Different qualification between a related rotate toward the sky and isolates look upward?

544


How union transformation is used?

579


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1497


Does an informatica transformation support only aggregate expressions?

602






What happens when a session fails and you click on recover?

647


What is the difference between STOP and ABORT options in Workflow Monitor?

687


what is mean by complex business rule ?

1712


How to start a workflow using pmcmd command?

703


Explain your project of banking domian.

1209


wf dont have integration severances how you can run?

1532


How can repository reports be accessed without sql or other transformations?

714


How to load last n records of file into target table - informatica

591


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1749


Enlist the various types of transformations.

546