how to connect two or more table with single source qualifier?
Answer Posted / 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 |
Post New Answer View All Answers
What is a code page?
without table how to come first record only in oracle?
Explain the shared cache and re-cache?
What is the difference between a connected look up and unconnected lookup?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is meant by active and passive transformation?
What is a rank transform?
What is parallel processing in informatica?
I have a flat file, want to reverse the contents of the flat file
Can u generate reports in Informatica?
How you can differentiate between connected lookup and unconnected lookup?
How would you join a node to the already existing domain?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the types of presistent cache in look up tr.
Explain what are the different types of transformation available in informatica.