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

Explain the different dimensions.

650


What do you mean by blocking transformation?

675


what is size of u r database?

1942


What is domain and gateway node?

801


How do you update the records with or without using update strategy?

756






Why do you use Mapping Parameter and mapping variable?

1377


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

645


How you prepared reports for OLAP?

1248


How you can differentiate between connected lookup and unconnected lookup?

709


How identifying bottlenecks in various components of informatica and resolving them?

686


What is meant by active and passive transformation?

678


Enterprise data warehouse your projects phase by phase explain?

1562


Different circumstance which drives informatica server to expel records?

635


Please let me know how to make Data masking in informatica..

1343


what is the hint? how to use it to reduce the query processing in program?

6674