How can Array size and Transation size is related

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
irajasekharhexa
Premium Member
Premium Member
Posts: 82
Joined: Fri Jun 03, 2005 5:23 am
Location: Bangalore
Contact:

How can Array size and Transation size is related

Post by irajasekharhexa »

Hi,

I've a doubt in defining the Array size and transaction size

Suppose if i take array size is 1000 is there any mathematical calculation to define the transaction size or is it optional to choose?
Rajasekhar
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Well... you do typically want Transaction Size to be a multiple of Array Size. So, with an Array Size of 1000 you might have a Transaction Size of 5000 or 10000 for example.

Not to send this careening off course, but keep in mind the fact that, if you are using a reject link, it will only really work 'properly' with an Array Size of 1.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply