reg update count

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

reg update count

Post by dnat »

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.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

How many nodes in your configuration file and have you specified a partitioning method?
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Post by dnat »

The job is running in single node
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply