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 / rampriya

Create a Oracle source with how much ever column you want
and write the join query in SQL query override. But the
column order and data type should be same as in the SQL query.

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the Methods For Creating Reusable Transformations?

1167


Tell me about Propagate functions in informatica

919


What is workflow? What are the components of the workflow manager?

1132


What does role playing dimension mean?

1044


What are batches?

1093


Differences between connected and unconnected lookup?

1211


How can informatica be used for an organization?

1211


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1273


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2010


lookup transformation with screenshots

4002


Explain what transformation and how many are there in informatica?

945


What are the uses of etl tools?

1122


What is data caches/ index caches?

1097


What is parallel processing in informatica?

1709


What are the mapping parameters and mapping variables?

1198