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.
Answer Posted / 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 |
Post New Answer View All Answers
As union transformation gives UNION ALL output, how you will get the UNION output?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is decode in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Explain the difference between mapping parameter and mapping variable?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what are 3 tech challenges/ common issues you face?
waht type of interface is used for testing the data in informatica
What is union transformation?
What are multi-group transformations?
explan ur project architecture?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
where to store informatica rejected data? How to extract the informatica rejected data?
How to create Target definition for flat files?
What is joiner transformation in informatica?