Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect two or more table with single source qualifier?
- 4 Answers
- 20815 Views
- IBM, I also Faced
- E-Mail Answers
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 are the differences between source qualifier and joiner transformation?
How to implement security measures using repository manager?
What happens when a session fails and you click on recover?
What is sq transformation?
Can we override a native sql query within informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How do you load alternate records into different tables through mapping flow?
What is event and what are the tasks related to it?
How to Create a folder using pmrep command?
Enlist the advantages of informatica.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is aggregate cache in aggregator transformation?
What are the databases that informatica can connect to windows?
How might one distinguish in the case of mapping is right or not without associating session?
What is a dimensional model?
