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
What happens when a session fails and you click on recover?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Is it possible to define a single node as a Gateway node as well as worker node?
How can we update a record in the target table without using update strategy?
Explain the different dimensions.
What is a snowflake schema?
Differences between version 7.x and 8.x.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is informatica powercenter repository?
Where can we find the throughput option in informatica?
What are the different versions of informatica?
What are the components of the workflow manager?
What is the difference between informatics 7x and 8x and what is latest version?