Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect two or more table with single source qualifier?
- 4 Answers
- 20750 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
How do you change a non-reusable transformation to reusable transformation?
whats the logic to load the lower level of granularity of data to fact table.
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 is the use of code page?
Explain how to import oracle sequence into informatica?
What are the guidelines to be followed while using union transformation?
Enlist the various types of transformations.
How to join three sources using joiner? Explain though mapping flow.
How an expression transformation differs from aggregator transformation?
How to do unit testing in informatica? How to load data in informatica ?
Describe an informatica powercenter?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Tell me about Propagate functions in informatica
What are multi-group transformations?
How can you generate reports in informatica?
