what is constraint based loading
Answers were Sorted based on User's Feedback
Constraint based load order defines the order of loading the
data into the multiple targets based on primary and foreign
keys constraints.
If i wrong means please send mail to chandranmca2007@gmail.com
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / usha
constraint based loading:-we need to enable the option in
session properties....
the main use of this optione is used to load the data if
the tables have PK and Fk relationship (or)which is used to
load the data if the tables having parent and chaild
realation .....
if we diidnt enable this option session will fail
| Is This Answer Correct ? | 4 Yes | 0 No |
In a concurrent batch if a session fails, can you start again from that session
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
What are events in workflow manager?
How to eliminate duplicates from flat file..what is the procedure
wat are deployement groups in informatica, how it will be used for developers
Why should we use star schema in datawarehouse design?
What is a sorter transformation?
when will we go for unconnected lookup transformation in Informatica?
What are active transformations.
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
From where we can start or use pmcmd?
What is Data Caches size?