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 / veeru
use the constrinat based loading order in session level and
set the dependency
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
explain abt ur project architecture?
Explain sql transformation in script mode examples in informatica
How can we update a record in the target table without using update strategy?
How to create Target definition for flat files?
Separate from a database, an information bazaar, and an information stockroom?
What is Session and Batches?
what are 3 tech challenges/ common issues you face?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Define the various join types of joiner transformation?
How do you change a non-reusable transformation to reusable transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the main issues while working with flat files as source and as targets ?
Target increases every day even though no new record was inserted
Explain Dataware house architecture .how data flow from intial to end?
What is a sequence generator transformation?