Page 1 of 1
Transaction adn Array size
Posted: Tue Apr 05, 2005 8:13 am
by kollurianu
Hi All,
What does Transaction level and Array size indicate , and how do they effect the job?
Thank you all,
Posted: Tue Apr 05, 2005 10:19 am
by ketfos
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
Posted: Tue Apr 05, 2005 10:42 am
by kollurianu
Thank you very much Ketfos.