MonetDB Bulk Loader
Description
The MonetDB Bulk Loader transform bulk loads data to MonetDB. This significantly speeds up data loading to MonetDB.
Options
General
Transform name : Specify the unique name of the MongoDB Output transform in the pipeline. Connection : Select your MonetDB database connection
General Settings tab
This tab contains the destination settings, buffer size and location for the logfile.
| Field | Description |
|---|---|
Target Schema | Specify the database schema that has to be used. |
Target Table | Specify the database table, use the Browse button next to this field to use a menu to select the table and schema |
Buffer size (rows) | Specify how many rows will be kept in memory before transferring to MonetDB |
Log file | Specify the location for the Bulk command logs returned from MonetDB |
Truncate table | Remove all data from the destination table before loading the data. |
Fully quote all SQL statements | Forces quotes around all objects when executing |
MonetDB Settings tab
This tab contains information about the temporary files that are generated to load the data.
| Field | Description |
|---|---|
Field separator | This is the separator that will be used in the Bulk copy command, it is not allowed to have this field in the input data. |
Field enclosure | The enclosure character used around values. |
Null values represented | Null values will be converted to this string, this allows to differentiate empty strings and null values. |
Encoding | File encoding used when generating the files for the copy statement. |