how to connect two or more table with single source qualifier?
- 4 Answers
- 19477 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 is the need for an etl tool?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Which development components of informatica have the highest usage?
What is meant by LDAP users?
How do we call shell scripts from informatica?
How to delete duplicate row using informatica?
scenario where i can use only concurrent execution of workflow.
What is main use of mapplet?
How many types of sessions are there in informatica.please explain them?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Write the unconnected lookup syntax?
Explain in detail scd type 2 through mapping.
Whats there in global repository
What is a repository? And how to add it in an informatica client?
Briefly define reusable transformation?
