Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 9663 Views
- Cognizant, I also Faced
- E-Mail Answers
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?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the cumulative sum and moving sum?
Define Pmrep command?
What is the difference between stop and abort in informatica
Design time, run time. If you don't create parameter what will happen
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Is it possible to revert a global repository to local one and why?
what is size of u r database?
How do you take back up of repository?
Can we get 1st record through Informatica(without sequence number).
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is persistent lookup cache?
Separate from an archive server and a powerhouse?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
