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

What is a joiner transformation?

550


what is informatica metadata?

597


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1844


Why do you use Mapping Parameter and mapping variable?

1281


What are the new features of Power Center 5.0?

1231






What are the different transaction levels available in transaction control transformation?

672


What are roles and groups and benefits of using them?

569


Write the advantages of partitioning a session?

742


What is data movement mode in Informatica and difference between them?

617


Explain why we use partitioning the session in informatica?

608


Explain sessions?

603


In warehouses how many schemas are there?

582


where to store informatica rejected data? How to extract the informatica rejected data?

598


How to go to the older version for a mapping?

600


What is blocking transformation?

716