Sign Up Login


  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

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

How can you define user defied event?

0 Answers  

Differentiate between reusable transformation and mapplet.

0 Answers  

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

.prm wirh repalce .txt is possible?

2 Answers  

What is the use of incremental aggregation?

2 Answers  

For more Informatica Interview Questions Click Here
Categories