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 load data into 3 target tables which are in
different schema but with the same name and same relational
connection at infromatica level ?
How to differentiate while loading ? and how to load ?

Answers were Sorted based on User's Feedback



How to load data into 3 target tables which are in different schema but with the same name and sam..

Answer / robin

use scheman name as prefix in the table name in session
properties.

Is This Answer Correct ?    5 Yes 0 No

How to load data into 3 target tables which are in different schema but with the same name and sam..

Answer / kritika

in the session we can give different connections based upon the database we want to load. In each table there will be different connection where we can give different database name

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More Informatica Interview Questions

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  


what is data driven in informatica

5 Answers   IBM,


can we generate reports in informatica ? How?

3 Answers  


how to work with mapplet designer in informatica?

7 Answers  


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

0 Answers  


If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,


how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,


How to fix the etl bugs..Tell me the process?

1 Answers   IBM,


What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,


have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,


Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  


If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,


Categories