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 is dimensional table?
What is domain and gateway node?
Can we create two repositories on same database instance in oracle?
Under what condition selecting sorted input in aggregator may fail the session?
Where do we use mapping variables in informatica?
What is olap (on-line analytical processing?
Performance tuning( what you did in performance tuning)
what is degenerated dimension?
Explain scd type 3 through mapping.
What you know about transaction control transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain sessions and how many types of sessions are there?
What are the components of workflow manager?
Informatica settings are available in which file?
What is the surrogate key?