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

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

Question Posted / palthepu_santosh


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

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  

What is DR strategy for Informatica project?

0 Answers  

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

What is the sequence generator transformation in informatica?

0 Answers  

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

What is the target load order?

3 Answers   HCL, Informatica,

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

what is INFORMATICA TESTING process

0 Answers  

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

For more Informatica Interview Questions Click Here
Categories