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

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  

what is $$$$?

0 Answers   TCS,

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,

Which transformation is needed while using the Cobol sources as source definitions?

0 Answers   Informatica,

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

Is it possible to revert a global repository to local one and why?

0 Answers  

Global and Local shortcuts. Advantages.

0 Answers  

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories