Hi,
Is there an option to commit rows in a table through ODBC stage after 'n' number of transactions? Since our input data is large it is timing out in the odbc stage.
transaction commit
Moderators: chulett, rschirm, roy
Re: transaction commit
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
It always helps to mention your database. Which ODBC stage are you referring to, the Enterprise stage I assume? The pdf reference for that stage mentions a dboption of -rowCommitInterval you can use to control that, suggest you give that a read.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers