Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect two or more table with single source qualifier?
- 4 Answers
- 20740 Views
- IBM, I also Faced
- E-Mail Answers
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
What are the main features of Oracle 8i with context to datawarehouse?
What is the function of look up transformation?
What is meant by target load plan?
What will be the approach?
Why do you use Mapping Parameter and mapping variable?
What is the need for an etl tool?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the advantages of informatica?
What does command task mean?
What is workflow? What are the components of the workflow manager?
What all are steps in up gradation of Informatica server?
What is an aggregator transformation?
What are the data movement modes in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
