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 |
what is the Default Source Option For Update Strategy Transformation?
What are batches?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
What is an expression transformation?
how can we calculate fact table size?
what is informatica metadata?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
why we are using surogate key in real time give me explanation
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
what type of transformation is not supported by mapplets?