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 |
Define pmcmd command?
how we can update a target table without update strategy and update override?
without dynamic lookup transformation how to insert new rows and update existing rows?
why we use informatica in our project?
how i will stop my workflow after 10 errors
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
in which situations do u go for starflake schema ?
What is Micro Strategy? Why is it used for?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
What is workflow? What are the components of the workflow manager?
what is filelist concept in informatica
How do you migrate data from one environment to another?