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
tell me the rules and responsblites in our project(my project is development)
Please let me know how to make Data masking in informatica..
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain the mapping variable usage example in informatica
How can you differentiate between powercenter and power map?
What is joiner change?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is the maplet?
What are the features of complex mapping?
How to load a Dimension ? and how to load a fact table?
How you can differentiate between connected lookup and unconnected lookup?
What is fact table? Explain the different kinds of facts.
What is primary and backup node?
What are the different options available for update strategy?
What do you mean by filter transformation?