Commit intervals in ODBC Enterprise stage
Posted: Wed May 12, 2010 10:11 am
We are working on Parallel extender on 8.1 on the AIX environment.
We are using ODBC enterprise stage to read and load data into MS SQL Sever 2005 tables.
How do we set commit intervals in this stage?
We will want commit to happen only after the entire load is complete. Incase the job fails due to various reasons, no record should get committed to the target table.
I am sure there must be a way out and requesting experts to help us out.
Thanks in advance
We are using ODBC enterprise stage to read and load data into MS SQL Sever 2005 tables.
How do we set commit intervals in this stage?
We will want commit to happen only after the entire load is complete. Incase the job fails due to various reasons, no record should get committed to the target table.
I am sure there must be a way out and requesting experts to help us out.
Thanks in advance