how to connect two or more table with single source qualifier?
- 4 Answers
- 19525 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
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is an expression transformation in informatica?
How can we use mapping variables in informatica?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How we can create indexes after completing the loan process?
server hot-ws270 is connect to Repository B. What does it mean?
How you can differentiate between connected lookup and unconnected lookup?
What is native users?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
write a query to retrieve the latest records from the table sorted by version(scd)
difference between informatica 8.1.1 and 8.6
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the command used to run a batch?
What is informatica etl tool?
