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

Is informatica power center designer has 64 bit support?

1 Answers  


IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,


I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  


get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,


What is Cognos script editor?

0 Answers   Cognizant,


I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,


What are the tasks that Loadmanger process will do?

1 Answers  


write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,


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?

0 Answers  


What are the types of lookup?

3 Answers   Wipro,


What is informatica? What exactly are the practical uses in real world

2 Answers  


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  


Categories