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
server hot-ws270 is connect to Repository B. What does it mean?
How might you approve all mappings in the archive all the while?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Enlist the various types of transformations.
How can you differentiate between powercenter and power map?
Define joiner transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
How do you set a varible in incremental aggregation
Explain the use of aggregator cache file?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the types of lookup transformation?
What is the commit type if you have a transaction control transformation in the mapping?
Differentiate between joiner and lookup transformation?
what is $$$$?
What if the source is a flat-file?