What is target update override

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


Please Help Members By Posting Answers For Below Questions

Explain how to import oracle sequence into informatica?

594


tell me the rules and responsblites in our project(my project is development)

1507


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

789


What you know about transaction control transformation?

563


Explain lookup transformation source types in informatica

702






What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

554


What is a filter transformation and why it is an active one?

564


What is meant by target load plan?

561


What are active and passive transformations?

654


What are data-driven sessions?

717


How do you load only null records into target?

742


Please let me know how to make encryption and decryption with example?

1475


what is the size of u r source(like file or table)?

1820


What is the function of union transformation?

621


What are the differences between joiner transformation and source qualifier transformation?

632