What is up date strategy and what are the options for update
strategy?
- 2 Answers
- 9272 Views
- I also Faced
- E-Mail Answers
Answer Posted / mkolari
We can use update strategy at two different levels
1) within a session :- When you are configuring a
session you can give instructions to treat a)all rows as
insert b)all rows as update c)data driven (use instructions
coded into the session mapping to flag rows for different
database operations.)
2) within mapping :- You can flag rows for
insert,update,delete or reject.
Don't forget to set "Treat source rows as" to Data Driven
in the session properties if you are flagging rows within
the mapping.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the meaning of up gradation of repository?
What do you mean incremental aggregation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is InformaticaPowerCenter?
Mention some types of transformation?
Can we create multiple integration service on single repository?
explan ur project architecture?
r u done any partitions in ur project?
What do mean by local and global repository?
How will the document be delivered to me?
What are the components of workflow manager?
How do you load first and last records into target table?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is lookup transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
