We can insert or update the rows without using the update strategy. Then what is the necessity of the update strategy?

Questions by cvgopal123   answers by cvgopal123

Showing Answers 1 - 27 of 27 Answers

Srinivas Kuncham

  • Feb 1st, 2007
 

Yes, we can insert or Update with out using Update Strategy by using the following logic.In session Properties set Treat Source Rows as Update and in Target Properties select Insert, Update else Insert options

pal

  • Feb 9th, 2007
 

Kiranvgris absolutely right, when we want different things to happen like insert, update, delete or reject in one mapping then we use update strategy.

  Was this answer useful?  Yes

anju

  • Mar 2nd, 2007
 

We can perform insert,update in session level by changing the session properties. in mapping level, insert and update operation are performed using the update strategy

  Was this answer useful?  Yes

hanu Ch Rao

  • Mar 2nd, 2007
 

Hi,
I think its possible to insert update records by using Dy. Lokkup concept without using Update Strategy.

Im not sure if its wrong pls reply me
thnq.

  Was this answer useful?  Yes

Jithendra

  • Mar 6th, 2007
 

Rao,

It is not possible to insert/update rows into a table with the help of Dynamic lkup transformation. Update strategy will have to be used in combination with Dynamic lkup transformation to flag the rows based on the value of NewLookupRow port.

Jithendra

  Was this answer useful?  Yes

dl_mstr

  • Feb 10th, 2008
 

Yes we can update and insert record from session properties  but there are two reasons why we should use update strategy
1) The mapping become readable
2) we can use condition for insert and update by using update strategy.



  Was this answer useful?  Yes

vskogirala

  • Feb 15th, 2008
 

In update strategy ,

1)An insert in the source an insert in the target

2)An update in the source is an update in the target


update strategy provides 4 types of data driven functions

1)DD_INSERT
2)DD_UPDATE
3)DD_DELETE
4)DD_REJECT


US can be implemented at 2 levels

1)MAPPING LEVEL
2)SESSION LEVEL


SESSION PROPERTIES OF UPDATE STRATEGY ARE

1)UPDATE AS UPDATE
2)UPDATE AS INSERT
3)UPDATE ELSE INSERT  (DEFAULT)

UPDATE STRATEGY IS SIMILAR TO SCD-TYPE 1

  Was this answer useful?  Yes

Mohan

  • Aug 12th, 2018
 

1. You cannot perform DD_Delete unless you have update strategy.
2. While updating a record, ideally created date should not be changed. for that we definitely have to create two targets (insert and update)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions