Count inserts, deletes and updates in a PowerCenter session

informatica-powercenter informatica
Averroes picture Averroes · Sep 6, 2012 · Viewed 8.3k times · Source

Is there a way in PowerCenter 9.1 to get the number of inserts, deletes and updates after an execution of a session? I can see the data on the log but I would like to see it in a more ordered fashion in a table.

Answer

Marek Grzenkowicz picture Marek Grzenkowicz · Sep 6, 2012

The only way I know requires building the mapping appropriately. You need to have 3 separate instances of the target and use a router to redirect the rows to either TARGET_insert or TARGET_update or TARGET_delete. Workflow Monitor will then show a separate row for the inserted, updated and deleted rows.

Related questions

Case Statements/Decode Function in Informatica

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based on my limited experience I feel case statements aren't supported. There is a decode function with similar functionality, but I …

Read More
How to dynamically give flat file source file name in session properties of informatica?

i have an issue where i get flat file with date and time extension to flat file name like test_28-10-2012.txt I can get the flat file name in mapping through checking the AddCurrentlyProcessedFileNameproperty in Source Analyzer,from …

Read More
Difference between Joiner and Union Transformation

I'm new to Informatica....What is the difference between Joiner and Union Transformation? Also, Should we use Router instead of Joiner, to increase performance when there are multiple sources?

Read More