We are using Update Strategy Transformation in mapping how can we know whether insert or update or reject or delete option has been selected during running of sessions in Informatica.

Questions by renukhareddy

Showing Answers 1 - 7 of 7 Answers

Rishi

  • Dec 5th, 2005
 

In Designer while creating Update Strategy Transformation uncheck "forward to next transformation". If any rejected rows are there automatically it will be updated to the session log file.

Update or insert files are known by checking the target file or table only.

  Was this answer useful?  Yes

sithusithu

  • Jan 4th, 2006
 

Operation           Constant               Numeric value

Insert                  DD_INSERT                      0

Update                DD_UPDATE                     1

Delete                 DD_DELETE                      2

Reject                  DD_REJECT                      3

Hope this will help you to find out.

Cheers,

Sithu

  Was this answer useful?  Yes

prasadns26

  • Jul 18th, 2006
 

hi,

if u r using an update strategy in ur mapping, there is no such oprtion to check or uncheck for these operations.when u have to perform any of the DML or database operations u have to code it in the UPD manually. so there is no chance for checking this. if u have used DD_UPDATE or DD_REJECT, u can only know it by querying the target table.if its rejected then through session log.

  Was this answer useful?  Yes

praveen katta

  • Jul 20th, 2007
 

Use a lookup transformation this will take a snapshot of the table before sending to update strategy. You can use active lookup, it will keep track of the data coming in and will help to identify new/old rows.

  Was this answer useful?  Yes

prade

  • Jun 26th, 2008
 

In general DWH scenario, we create TABLE_REJECT or FILE_REJECT to keep a check of the rejected records. For all the updates happening we keep timestamp or some other flag in the database.

Before the update strategy itself if you know under what circumstances you need to perform insert, update, reject or delete put an indicator and check the indicator value in the update strategy to write to the target. 

OR 

use a router grouping on the indicator before the update strategy and create different groups for update, reject, delete or insert and write into the file. This is just for testing puproses. 

  Was this answer useful?  Yes

samirdesai999

  • Jun 13th, 2009
 

use following
expression in update strategy transformation.
iif ( condition 1 , DD_INSERT,
  condition 2 , DD_UPDATE,
  condition 3 , DD_DELETE,
  DD_REJECT -- for default)

and set session property as data driven, You can cross check these conditions values during session debug runs.

  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