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

What is constraint based loading exatly? And how to do this?
I think it is when we have primary key-foreign key relation
ship. Is it correct?
please answer me.
Advance Thanks.

Question Posted / manojkumar

Answers were Sorted based on User's Feedback



What is constraint based loading exatly? And how to do this? I think it is when we have primary key..

Answer / om

Constraint Based Load order defines load the data into
multiple targets depend on the primay key foriegn key reltion.

set the option is: Double click the session
Configue Object check the Constraint Based Loading

Is This Answer Correct ?    3 Yes 0 No

What is constraint based loading exatly? And how to do this? I think it is when we have primary key..

Answer / raja

yes it is correct.it is there in target.u enable the key.

Is This Answer Correct ?    1 Yes 0 No

What is constraint based loading exatly? And how to do this? I think it is when we have primary key..

Answer / guest

yes. both tables shuld maintain relationship. like emp dept
tables

Is This Answer Correct ?    1 Yes 1 No

What is constraint based loading exatly? And how to do this? I think it is when we have primary key..

Answer / c manojkumar

Thanks a lot.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

What are the static cache and dynamic cache in informatica?

0 Answers  

what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

What is status code in informatica?

0 Answers  

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

What is substr in informatica?

0 Answers  

how tokens will generate?

0 Answers  

Explain pmcmd command usage in informatica

0 Answers   Informatica,

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

For more Informatica Interview Questions Click Here
Categories