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.
- 4 Answers
- 6660 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many transformations can be used in mapplets.
How to generate sequence numbers?
How can one identify whether mapping is correct or not without connecting session?
Can informatica load heterogeneous targets from heterogeneous sources?
Define filter transformation?
What is the benefit of partitioning a session?
What are the mapping parameters and mapping variables?
How big was your fact table
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is a sequence generator transformation?
Global and Local shortcuts. Advantages.
How to create or import flat file definition in to the warehouse designer?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What do you mean by worklet?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
