What is Target Update Override? What is the Use ?

Answer Posted / srinu

When we don't have primary keys defined on database level.
And still we need update on this target from Informatica.
We neeed to define keys at informatica level and use update
override in target property. This way we can update the
table.

<source>-geekinterview.com

Any Queries or Corrections
srinu.srinuvas@gmail.com

Is This Answer Correct ?    19 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is lookup transformation?

675


What is joiner transformation in informatica?

693


How to load the data from people soft hrm to people soft erm using informatica?

625


What is dimensional table? Explain the different dimensions.

741


What is depict expression change?

692






Define sessions in informatica etl?

683


What are active and passive transformations?

699


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1391


What is rank transformation?

656


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7861


How do you convert single row from source into three rows into target?

704


what is size of u r database?

1920


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.

860


How to differentiate between the active and passive transformations?

684


What is blocking transformation?

783