My source has 100 records. I have targets say in number 5.
all target tables has parent and child relationships in
between themselves. Now I want to load all 100 records into
all targets. How U can ensure that record inserted in parent
and then loaded into child.
Answers were Sorted based on User's Feedback
Answer / veeru
use the constrinat based loading order in session level and
set the dependency
Is This Answer Correct ? | 15 Yes | 0 No |
Answer / rekha
By using constraint load ordering in session level (gofor
config tab -->, then 1st option is constraint based load
ordering) we can achieve this
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / naveen
Use the target load plan & constriant based loading order in
session level and set the dependency
Is This Answer Correct ? | 1 Yes | 2 No |
Informatica settings are available in which file?
how to join the two flatfiles using the joiner t/r if there is no matching port?
Where do you create/define mapping parameter and mapping variable?
What are the phases in SDLC?
Mapplets can you use an active transformation in a mapplet,
expain about the tune parameters?
what is the size of u r source(like file or table)?
What are the tuning techniques you applied during your last project
Why we use ENABLE HIGH PRECISION in session properties?
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
what are presession,postsession success and postsession failure commands ?
What is informatica? What exactly are the practical uses in real world