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 |
What is power play plug in?
why we use informatica in our project?
What is operational data source (ODS)?
one source to target loading insert new rows and update existing rows?
update strategy transformation in informatica
what is the architecture of any Data warehousing project?
How to display First letter of Names in Caps?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Which are the different editions of informatica powercenter that are available?
Define Pmrep command?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica