Define update strategy?
- 1 Answers
- 1382 Views
- I also Faced
- E-Mail Answers
Answer / Sagar Jain
In Informatica, an update strategy defines how to handle records during an update operation. Common update strategies include Overwrite Update (replacing existing records with new ones), Append Only (adding new records without modifying old ones), and Upsert (inserting or updating records as needed based on a unique key).
| Is This Answer Correct ? | 0 Yes | 0 No |
whatis the default data driven operation in informatica
what is the flat file partition and where have to specify it
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
Design a mapping to load a target table with the following values from the above source?
performance tuning of Informatica
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
What is workflow? What are the components of the workflow manager?
What is deployment group?
whether Sequence generater T/r uses Caches? then what type of Cache it is
Teradata 
