For sessions that perform multiple-record writes, PWXPC issues this message and PWXPC_12189 periodically to report the progress of fetching rows from the cache and writing them to the target. The message displays following statistics:
rows_requested
is the number of rows that PWXPC has passed to the sequencing and queuing cache.
rows_applied
is the number of rows that have been successfully read from the sequencing and queuing cache.
rows_rejected
is the number of rows that were rejected as orphans. Orphans are records for which no record exists in the cache with a primary key that matches the foreign key of the orphan.
Because multiple-record writes require the
Confirm Write Off
target connection setting, these writes are asynchronous with respect to PowerCenter. Depending on input data to the writer, row statistics reported in the session log and Workflow Monitor might not always reflect the number of rows that have actually been written to the target.