This option enables you to set the default action for Managing characters in column names.
This option enables you manage unsupported characters in column names when loading data from a source table, e.g. spaces in the source column names.
Option | Description |
|---|---|
Retain All | Set this field if you want to retain all characters in the column name conversion, when you create a Load table from a source table with unsupported characters in its column names. |
Convert to Underscore | This is the default setting. RED replaces the spaces in the source column names, when you create a Load table via drag and drop of a source table from the right pane to the middle pane of the Builder window. |