How will you update the row without using update statergy?

Answer Posted / ganesh

1) If the target table doesn't have primary key, then using
update override we can update the records.

2) If target table have primary key, then we have option
called update else insert in session properties. Based upon
that we will update the records.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

tell me the rules and responsblites in our project(my project is development)

1495


Please let me know how to make Data masking in informatica..

1267


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

603


Explain the mapping variable usage example in informatica

634


How can you differentiate between powercenter and power map?

623






What is joiner change?

677


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

788


What is the maplet?

620


What are the features of complex mapping?

643


How to load a Dimension ? and how to load a fact table?

955


How you can differentiate between connected lookup and unconnected lookup?

611


What is fact table? Explain the different kinds of facts.

614


What is primary and backup node?

694


What are the different options available for update strategy?

578


What do you mean by filter transformation?

553