What is constraint based loading exatly? And how to do this? I think it is when

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

4 Answers
7365 Views
I also Faced
E-Mail Answers

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

Explain scd type 3 through mapping.

0 Answers

what is incremental aggregation ,with example?

2 Answers

Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers

expain about the tune parameters?

0 Answers TCS,

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers IBM,

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers Cegedim, IBM, TCS,

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers iNautix,

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers TCS,

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers TCS, Wipro,

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers IBM,

What is informatica metadata and where is it stored?

0 Answers

For more Informatica Interview Questions Click Here