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
scenario where i can use only concurrent execution of workflow.
Different qualification between a related rotate toward the sky and isolates look upward?
How union transformation is used?
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?
Does an informatica transformation support only aggregate expressions?
What happens when a session fails and you click on recover?
What is the difference between STOP and ABORT options in Workflow Monitor?
what is mean by complex business rule ?
How to start a workflow using pmcmd command?
Explain your project of banking domian.
wf dont have integration severances how you can run?
How can repository reports be accessed without sql or other transformations?
How to load last n records of file into target table - informatica
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.
Enlist the various types of transformations.