Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect two or more table with single source qualifier?
- 4 Answers
- 20941 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 all join we can perform in LOOKUP transformation?
generate date / time dimension in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Which files are created during the session rums by informatics server?
How to elaborate tracing level?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are mapplets? How is it different from a Reusable Transformation?
Explain what are the different types of transformation available in informatica.
What is a repository? And how to add it in an informatica client?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How do we call shell scripts from informatica?
Define mapplet?
Describe data concatenation?
What is the scenario which compels informatica server to reject files?
How can we use batches?
