Answer Posted / ash
By Default the intergration service updates the target
based on key columns. But we might want to update non-key
columns also,at that point of time we can override the
UPDATE statement for each target in the mapping.The target
override affects only when the source rows are marked as
update by an update strategy in the mapping.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the use of transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is event and what are the tasks related to it?
What is deployment group?
How to use procedural logic inside infromatica?
What are the measure objects?
What is complex mapping?
what is index?how it can work in informatica
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a grid in Informatica?
How can a transformation be made reusable?
Mention few advantages of router transformation over filter transformation.
How to extract sap data using informatica? What is abap? What are idocs?
complex mapping ur project u r invlve can u explain and give real time example give me ?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N