If I have set the property Treat Source Rows as Insert and
for the target properties I have checked the boxes Update as
Update, what will happen to incoming rows?
What exactly is the use of these check boxes and in which
scenarios we use them. Also what is the sequence in which
informatica understands these properties.Does it takes
whatever is defined in treat source rows as property or it
is in any other way. Please explain.

Answer Posted / sumit

Session Will Fail. Unable to Insert into the Target table error.

Please correct me if i am wron

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1853


What is the use of an aggregator cache file?

687


What is Data Caches size?

654


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

807


What is intricate mapping?

590






What is main use of mapplet?

658


What do you mean by enterprise data warehousing?

644


How many numbers of sessions can one group in batches?

618


In informatics server which files are created during the session rums?

635


How to configure mapping in informatica?

674


While importing the relational source definition from the database, what are the metadata of source that will be imported?

788


What is primary and backup node?

694


How to generate sequence numbers?

616


Explain informatica architecture - version 8 / 9

668


Differentiate between joiner and lookup transformation?

613