When I look at many of the workflow last sessions runs in the workflow monitor I see the number of records that are picked by the transformation is different than the number of records that get updated or inserted in the target table.
For example my sql transformation picks 80,742 rows from the source table. but only 29,813 rows get loaded into the target table.
On further analyzing the workflow log file I can see it loaded both insertable records and updatable records:
WRT_8036 Target: W_SALES_ORDER_LINE_F (Instance Name: [W_SALES_ORDER_LINE_F]) WRT_8038 Inserted rows - Requested: 15284
Applied: 15284 Rejected: 0 Affected: 15284 WRT_8041 Updated rows - Requested: 14529 Applied: 14529 Rejected: 0 Affected: 14529
WRITER_1_*_1> WRT_8035 Load complete time: Wed Mar 19 04:41:24 2014
I am not able to figure out why would the workflows load lesser records than what source sql gives. and I would really appreciate some help in this matter.
Thanks