Difference

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
Nagaraj
Premium Member
Premium Member
Posts: 383
Joined: Thu Nov 08, 2007 12:32 am
Location: Bangalore

Difference

Post by Nagaraj »

Hi There,

Can anyone please tell me the difference between

Transaction Size (number of records to read / commit while Write) and Array Size(???)
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Array Size is the number of records in each network packet - i.e. to send across the network to the database at the same time. Transaction Size should be an even multiple of the Array Size when not set to zero.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Nagaraj
Premium Member
Premium Member
Posts: 383
Joined: Thu Nov 08, 2007 12:32 am
Location: Bangalore

Hi

Post by Nagaraj »

chulett thanks for the information, But i could read it fully :( (Premium memborship Problem).
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

At least that 'problem' is one that is easily solved. :wink:
-craig

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