Hi,
I am updating a target table taking the records from source. There are 10 records in the input file . So, ideally the number of records updated in the target table is 10, but the log shows that 20 records are updated. what could be the reason.
reg update count
Moderators: chulett, rschirm, roy
How many nodes in your configuration file and have you specified a partitioning method?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please post the job score. You will need to set APT_DUMP_SCORE to True to achieve this - easiest way is to add it as a job parameter.
Please also post your job design. Otherwise we'd be wasting time guessing at possible causes. There are several, for example lookups that return multiple rows, joins with duplicates on the inputs, and so on.
Please also post your job design. Otherwise we'd be wasting time guessing at possible causes. There are several, for example lookups that return multiple rows, joins with duplicates on the inputs, and so on.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.