I'm trying to find out how to set the commit level of a job so that it commits after xxx number of rows. I've looked through the Ascentials documentation, the PeopleSoft warehouse documentation and browsed through this forum. I haven't been able to find out how to do this, although I did come across someone mentioning commit levels.
Any help is appreciated.
Set Commit After Set Number of Rows
Moderators: chulett, rschirm, roy
I don't have access to a 7.5 server right now, so can't check the DRS stage right now.
Be careful of the Transaction Size on the General tab, it is mostly there for backwards compatibility with older releases - at least that's the case with the OCI stages. If there is a specific Transaction Handling tab with a 'Rows per transaction' setting, then the general setting will be ignored. If all you can find is the general one, then that would be the one to set.
Be careful of the Transaction Size on the General tab, it is mostly there for backwards compatibility with older releases - at least that's the case with the OCI stages. If there is a specific Transaction Handling tab with a 'Rows per transaction' setting, then the general setting will be ignored. If all you can find is the general one, then that would be the one to set.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers