Batch Insert Mode - SuperCHANNEL

SuperCHANNEL has two modes it can use to insert records from the source database into the target:

Batch mode - records are inserted in groups.
Classic mode - records are inserted one at a time.

Batch mode is more efficient, but will only be used if the source database meets certain criteria. If SuperCHANNEL is unable to use batch mode, it will automatically revert to classic mode.

Wherever possible, you should design your source or staging database so that batch insertion will be possible.

Batch Mode Feature Support

SuperCHANNEL batch mode currently only supports a subset of SXV4 features:

Supported by Batch Mode...	Not Supported...
32 and 64 bit integer columns. String columns. Double precision floating point number columns. Fact to classification foreign keys. Fact table primary keys. Fact to fact foreign keys. The "bin" cleansing rule. The "add to classification" cleansing rule (limited to 60,000 cleansing errors).	Date/Time columns. The "stop" cleansing rule. The "skip" cleansing rule. Nullable columns. Compound primary keys.

Configure Batch Mode

Batch mode is enabled by default and will be used automatically if the source database meets the above criteria. However, you can disable batch mode by editing config.txt, the SuperCHANNEL configuration file (by default, this file is located in C:\ProgramData\STR\SuperCHANNEL\bin).

The parameter str.usebatch controls whether batch mode is available. By default it is set to true (SuperCHANNEL will use batch mode if possible), but you can change it to false to turn off batch mode regardless of whether the source database supports it:
CODE
```
str.usebatch=false
```
The parameter str.cleansing.printerrors controls whether or not messages about cleansing actions are output to the logs when using batch mode. By default, this parameter is set to true (SuperCHANNEL will output messages about cleansing actions), but you can turn off these messages by changing the value to false:
CODE
```
str.cleansing.printerrors=false
```