Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is dimensional table? Explain the different dimensions.

1244


list out all the transformations which use cache?

1239


What is domain in terms of informatica?

1056


What all are steps in up gradation of Informatica server?

1093


Slowly changing dimensions, types and where will you use them

1767


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2248


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

2006


What are the components of the workflow manager?

1179


What are mapplets? How is it different from a Reusable Transformation?

1134


Different circumstance which drives informatica server to expel records?

1040


 Informatica Checkpoints

3375


How to Create a folder using pmrep command?

1218


Mention few power centre client applications with their basic purpose?

996


How to do the error handling of if ur source is flatfiles?

2014


What is the function of aggregator transformation?

1132