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

how we can load rejected record's at run time?(not through bad files)

2120


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1785


What is meant by LDAP users?

862


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1882


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

757


How big was your fact table

1489


Write the unconnected lookup syntax and how to return more than one column.

821


Explain the etl program with few examples.

735


Where are the source flat files kept before running the session?

821


Explain how many types of dimensions are available in informatica?

764


Differences between connected and unconnected lookup?

836


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1530


Design a mapping to load the cumulative sum of salaries of employees into target table?

1164


How to update source definition?

834


What is deployment group?

866