Transaction adn Array size

kollurianu · Post by **kollurianu** » Tue Apr 05, 2005 8:13 am

Hi All,

What does Transaction level and Array size indicate , and how do they effect the job?

Thank you all,

ketfos · Post by **ketfos** » Tue Apr 05, 2005 10:19 am

hi,
Transaction handling - If trasaction grouping is enabled, Rows per transaction, in datastage, determines the number of rows written before data is commited in database

If value is set to 0, then all rows are to be written before they are committed.

Array Size is the number of rows that can be fetch in each call to database from datastage or vice versa.

Ketfos

kollurianu · Post by **kollurianu** » Tue Apr 05, 2005 10:42 am

Thank you very much Ketfos.