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

Repository user profiles

1458


is it possible to index the data in cache of lkp transformation ?

1621


What is the reusable transformation?

733


What do you mean by filter transformation?

644


What is a grid in Informatica?

716






Tell me about MD5 functions in informatica

603


How can repository reports be accessed without sql or other transformations?

824


Define mapping and session?

675


How do you set a varible in incremental aggregation

1534


Enterprise data warehouse your projects phase by phase explain?

1560


What is depict expression change?

707


difference between informatica 8.1.1 and 8.6

3349


Whats the difference between informatica powercenter server, repositoryserver and repository?

794


Write the advantages of partitioning a session?

850


Informatica settings are available in which file?

684