array size

[venkat n]

Hi All

We are using arraysize as 5000 in source, Why it is recommended
Is there any reason for this?
In target we are using arraysize as 32363 actually I am asking what is the background logic here. why these values are recommended?

I thought as this as the buffersize, Datastage captures data upto that buffer size whats ths value we gave in the array size
Am I correct?

[ray.wurlod]

It's the number of rows of data values sent at a time to the database server by DataStage. It should be a multiple of the "rows per transaction" figure, for efficiency. You can find out more by searching on this forum.