What is up date strategy and what are the options for update
strategy?
- 2 Answers
- 9459 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
Explain the features of connected and unconnected lookup.
What is source qualifier transformation in informatica?
What is target load order?
Is there any way to read the ms excel datas directly into informatica?
How to extract sap data using informatica? What is abap? What are idocs?
Difference between Target-based loading and constraint-based loading?
How to do unit testing in informatica? How to load data in informatica ?
What are the designer tools for creating transformations?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
can anyone explain me about retail domain project in informatica?
what is the complex transformation you used in informatica
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Mention few power centre client applications with their basic purpose?
What do you understand by SOA of Informatica?
Design time, run time. If you don't create parameter what will happen
