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

Why we use partitioning the session in informatica?

2 Answers  

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,




what are presession,postsession success and postsession failure commands ?

1 Answers  

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers   Wipro,

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

What are some examples of informatica etl programs?

0 Answers  

For more Informatica Interview Questions Click Here
Categories