array size and transaction size

4friends · Post by **4friends** » Wed Nov 21, 2007 1:43 am

any one can explain array size and transaction size with uses,where we get these in datastage

ray.wurlod · Post by **ray.wurlod** » Wed Nov 21, 2007 5:00 am

I did, years ago. Search the forum.

chulett · Post by **chulett** » Wed Nov 21, 2007 6:43 am

Or have a chat with your DBA.

baglasumit21 · Post by **baglasumit21** » Fri Nov 30, 2007 1:16 am

4friends wrote:any one can explain array size and transaction size with uses,where we get these in datastage

The array size gives the numbe rof rows to be cached before writing them to database
The transaction size gives the number of rows after which the transaction is to be commited to database.

Both are present in the input tab (appears when you are writing data to database) of database stages like (Oracle, DB2, etc).

DSXchange

array size and transaction size

array size and transaction size

Re: array size and transaction size