Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

Batch Data Cleansing


Overview

The Jet Data Manager has the ability to split an INSERT statement up in batches during data cleansing, i.e.
when copying data from the transformation view to the valid table. This saves log space on the SQL Server which gives you better performance on large tables with millions of rows.

Process

Enabling Batch Data Cleansing
To enable batch data cleansing, follow the steps below.

  1. On the Data tab, in a data warehouse, right click on the table you wish to use batch data cleansing on and click on Settings.
  2. Click on the Performance tab and select Enable batch data cleansing.
  3. (Optional) Enter the number of records you would like each batch to contain in Batch size. The default is 100,000.
  4. Click on OK.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments