Interested to Buy Any Domain ? << Click Here >> for more details...
What is up date strategy and what are the options for update
strategy?
- 2 Answers
- 10237 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
Why do we need informatica?
What are pre and post-session shell commands?
What are the guidelines to be followed while using union transformation?
What is the sql query overwrite in source qualifier in informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is Session and Batches?
Could you explain what is enterprise data warehouse?
How to extract sap data using informatica? What is abap? What are idocs?
What are the settings that you use to configure the joiner transformation?
What is primary and backup node?
What are active transformations.
What are the main features of Oracle 8i with context to datawarehouse?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is a joiner transformation and why it is an active one?
How to load the data from a flat file into the target where the source flat file name changes daily?
