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 are the difference between Informatica 7.1 and 8.1?
How to extract sap data using informatica?
What are the uses of etl tools?
Please let me know how to make encryption and decryption with example?
what are challenges that you faced in testing? give solution to it?
In informatica workflow manager, how many repositories can be created?
can we override a native sql query within informatica? Where do we do it?
Explain the pipeline partition with real time example?
can you use flat file for repository?why?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
What is decode in static cache?