How will you update the row without using update statergy?
Answer Posted / g. manthiramoorthy
You can set the property at session level
"TREAT SOURCE ROWS AS: "Update"
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are roles and groups and benefits of using them?
How to extract sap data using informatica? What is abap? What are idocs?
Define joiner transformation?
What is the commit type if you have a transaction control transformation in the mapping?
Suppose we do not group by on any ports of the aggregator what will be the output?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Differentiate between a database and data warehouse?
Explain the informatica workflow?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the different types of repositories created using informatica?
How to convert multiple rows to single row (multiple columns) in informatica
How would you join a node to the already existing domain?
What is complex mapping?
What happens when a session fails and you click on recover?