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 |
Design time, run time. If you don't create parameter what will happen
What are 2 modes of data movement in Informatica Server?
How to compare Source and Target table, without using dynamic lookup?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
How to Join Tables my Source is having 15 table target is one?
what is Partitioning ? where we can use Partition?
What is the filename which you need to configure in UNIX while installing infromatica?
Can we combine a flatfile and a database table using an UNION transformation?
how to duplicates from expression transformation without using sorter before that
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
what is fact table?