DSQuest

 Profile Answers by DSQuest 

• May 7th, 2010

 

I Suppose it is called "Array Size"....

Array Size is mainly used to increase the buffer during Write operations into a Oracle DB in a Server job using the Oracle OCI stage.

This comes of great use to increase the performance of a job especially when the volume of data to be written (Insert, Upsert, Update) is huge.

Typically the options that can be "Important" in OCI stage depends on the nature of job, however the other option that can be of general importance is the Transaction Size, but in the newer versions there is separate tab called "Transaction Handling" which takes care of it, the number of rows you mention here will be written into the Target DB before a Commit is made and hence improves the performance.

Mili Jon

 Profile Answers by Mili Jon 

• Jan 16th, 2011

 

Array size is a property of OCI stage which help to reduce the context switch between DataStage and Oracle database. We should keep this in mind that however it help us reducing the context switch but this can lead the metadata repository database toward having deadlocks (if the meta data repository is Sql Server). Having large array size would improve the performance of the OCI stage as it will fasten the write operation.