Informatica - Update Strategy

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 640 of 644

Update Strategy

In which situation do we use update strategy?

Total Answers and Comments: 8

Last Update: October 03, 2009 Asked by: saravanan.eswaran

Sponsored Links

Best Rated Answer

—

Submitted by: abha.sinha

Update Strategy can be used whenever we need to update some existing value in database. For an update strategy we need to have a primary key.

Above answer was rated as good by the following members:
rgvendra, avneeshrathor

May 05, 2009 07:48:25

abha.sinha

Member Since: May 2009 Contribution: 1

RE: Update Strategy

Update Strategy can be used whenever we need to update some existing value in database. For an update strategy we need to have a primary key.

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

May 18, 2009 16:18:51

NOTNULL

Member Since: May 2009 Contribution: 2

RE: Update Strategy

Update transformations how to treat the data within the transformation means normally insertion will take place in the Informatica. If you update or delete means treat the data differently we use update strategy transformations

Like dd_insert (not mandatory)
dd_update (for updation)
dd_delete (for deletion)

Is this answer useful? Yes | No

2 0

Overall Rating: +2

June 02, 2009 02:21:17

pooja.verma

Member Since: June 2009 Contribution: 2

RE: Update Strategy

Its always performance friendly to use Update strategy than informatica "Update else Insert" session target property.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 16, 2009 02:07:24

sahan

Member Since: July 2009 Contribution: 10

RE: Update Strategy

You can use the update strategy transformation when you want to update the existing values in the target. For this you need a primary key in the target.

Is this answer useful? Yes | No

July 16, 2009 09:58:32

seerum

Member Since: July 2009 Contribution: 1

RE: Update Strategy

If you want to perform insert update delete based on some conditional clause then you can choose this and when it is not possible for other types of update procedures in Informatica. (necessary condition is target should have a primary key.)

Is this answer useful? Yes | No

July 29, 2009 02:22:22

chiranjoydas

Member Since: July 2009 Contribution: 1

RE: Update Strategy

Update Strategy is used in case fo Updating a record if the same exists in the table. For that we need to have a primary key in the Informatica level even if the same is not present in database level. If no key is defined we need to use 'update override' in the target. Also when using this transformation click the 'Data Driven' property in the Session.

Is this answer useful? Yes | No

August 06, 2009 05:58:09

itisanimesh

Member Since: June 2009 Contribution: 4

RE: Update Strategy

Update strategy transformation is an Active and Connected transformation. It is used to update data in target table either to maintain history of data or recent changes. You can specify how to treat source rows in table insert update delete or reject

Is this answer useful? Yes | No

October 03, 2009 03:46:04

subbarao_mvs

Member Since: October 2009 Contribution: 2

RE: Update Strategy

Update Strategy is an active and connected. Generally we use update strategy before target. To Insert or update or delete or reject rows coming from the source to target. The constants we use in update strategy transfromation are:

DD_INSERT OR 0 --> INSERTING ROWS
DD_UPDATE OR 1 --> UPDATING ROWS
DD_DELETE OR 2 --> DELETING ROWS
DD_REJECT OR 3 --> REJECTING ROWS

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank