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
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is the cumulative sum and moving sum?
tell me about your project functionality
Enlist the tasks for which source qualifier transformation is used.
Explain lookup transformation in informatica
What do you mean by blocking transformation?
Explain direct and indirect flat file loading (source file type) - informatica
design of staging area?
How we can use union transformation?
without table how to come first record only in oracle?
What are the differences between oltp and olap?
What is a stored procedure transformation?
According to his methodology what all you need before you build a datawarehouse
What is lookup change?
What is standalone command task?