Hi All,
What does Transaction level and Array size indicate , and how do they effect the job?
Thank you all,
Transaction adn Array size
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
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
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
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm