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 |
How would you copy the content of one repository to another repository?
performance tuning of Informatica
what is mapping optimization? wat are the techniques for tat
how to obtain performance data for individual transformations.
What are the tuning techniques you applied during your last project
can a port in expression transf be given the name DISTINCT
What are the phases in SDLC?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
Separate from an archive server and a powerhouse?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
What is the difference between Power Centre and Power Mart?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?