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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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 ?

Question Posted / manojkumar challagundla

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

What does role playing dimension mean?

0 Answers  

What is a unit Testing?

1 Answers  

Can i create a lookup table without cache.

7 Answers   iGate,

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

what is the monster dimension plz give me one example

2 Answers   EDS,

how can we calculate fact table size?

1 Answers  

Explain the scenario which compels informatica server to reject files?

0 Answers  

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

Why you use repository connectivity?

3 Answers   Yash Technologies,

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

what is difference between COM & DCOM?

1 Answers   Satyam,

what is the incremental agrrigation?

2 Answers   Cap Gemini,

For more Informatica Interview Questions Click Here
Categories