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
What is a joiner transformation?
what is informatica metadata?
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.
Why do you use Mapping Parameter and mapping variable?
What are the new features of Power Center 5.0?
What are the different transaction levels available in transaction control transformation?
What are roles and groups and benefits of using them?
Write the advantages of partitioning a session?
What is data movement mode in Informatica and difference between them?
Explain why we use partitioning the session in informatica?
Explain sessions?
In warehouses how many schemas are there?
where to store informatica rejected data? How to extract the informatica rejected data?
How to go to the older version for a mapping?
What is blocking transformation?