DSXchange

Hi All,
I am loading data from DB2 table to another DB2 table. I want to generate a report that will give me details of the load like:

1. Number of rows processed.
2.Start time and time
Input number of rows.
3. Aggregated values of the Numeric fields processed. e.g. Total Sales in Dollars for all the Customers of A particular Store.
4.Rejected number of rows


Please let me know how to achieve this in Parallel extender.

You need to download EtlStats.zip from http://www.duke-consulting.com/DataStage_Tips_plain.htm. This is also posted on ADN. It will give you row counts for any or all your jobs and post them to Oracle or whatever database.

Aggregated values are another issue. You need to build in logic for that.