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


Is it necessary to maintain the primary-foreign key relation
ship between the targets in informatica while loading using
constarint based loading or it is required only at database
level ??



Is it necessary to maintain the primary-foreign key relation ship between the targets in informatic..

Answer / john

If they have already defined at databse level,then what is
the necessity of maintain the primary-foreign key
relationship at Informatica level.You just import those
tables from the database and load the data by developing
the mapping.but enable the option "constraint based load
ordering"in session config objects before you are going to
run the session. why because
informatica server(Integration Service) doesn't know the
relatioship between the target tables which you are going
to load eventhough they have already defined at databse
level.So you should use the option "Constarint Based load
ordering".
Then only Informatica server will check relationship
between the those tables and first it will load data in the
parent table(which has Primary key) and then child table
(which has foreign key)

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,


How do you change a non-reusable transformation to reusable transformation?

0 Answers  


hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  


what are types of dimentions?

3 Answers  


Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  


Why touse stored procedure in ETL Application?

2 Answers  


What is the difference between Power Centre and Power Mart?

5 Answers   TCS,


What is status code in informatica?

0 Answers  


What are parallel querys and query hints?

1 Answers  


suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,


What is a grid in Informatica?

0 Answers  


How many ways you create ports?

1 Answers  


Categories