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 the difference between stop and abort in informatica
What is a pre-defined event and user-defined event?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Name the different lookup cache(s)?
Differentiate between a repository server and a powerhouse?
How to delete duplicate row using informatica?
Separate from a database, an information bazaar, and an information stockroom?
How to generate sequence numbers using expression transformation?
Describe expression transformation?
design of staging area?
what is INFORMATICA TESTING process
What is confirmed fact in dataware housing?
without table how to come first record only in oracle?
How identifying bottlenecks in various components of informatica and resolving them?
What is mapplet in informatica?