Export Behavior tab

Use this tab to clear the destination table before exporting and to exclude zeros from the exported data. You can use these options on the Export Behavior tab:

Clear Destination Table Before Export

Determines whether the data is removed from the target table before export.

Note: This option is not displayed if Database is set to Datalake.

Exclude Zeros from Export

Determines whether data records with all numeric properties in the mappings table having values of 0 (zero) or nil are exported. Possible values:

On: The records (rows) are suppressed from the export.
Off: The records (rows) are included in the export.

Note:

This option can be used in combination with Export Filter that is defined.
This tab is available only if Interface Direction is set to Export.