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 dimensional table? Explain the different dimensions.
list out all the transformations which use cache?
What is domain in terms of informatica?
What all are steps in up gradation of Informatica server?
Slowly changing dimensions, types and where will you use them
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the components of the workflow manager?
What are mapplets? How is it different from a Reusable Transformation?
Different circumstance which drives informatica server to expel records?
Informatica Checkpoints
How to Create a folder using pmrep command?
Mention few power centre client applications with their basic purpose?
How to do the error handling of if ur source is flatfiles?
What is the function of aggregator transformation?