TDE Writer Feature Type Properties: Format Parameters
To access format parameters, open the Feature Type Properties dialog by clicking the properties button on a feature type in the workspace. These parameters are applicable only to the selected feature type.
These parameters apply only to a selected feature type, not to the entire writer.
Tip: If a feature type parameter listed here conflicts with a writer-level parameter, then the writer parameter will be ignored and this feature type parameter will be used.
Table Settings: General
This parameter controls how the feature type handles destination tables. These options are available:
- Create If Needed: Create destination table if it does not exist. Table will be created when the first input feature is processed. If no features are sent to a feature type, then the corresponding table will not be created. If the table exists, it will be appended to unless geometry is being written. If geometry is being appended to an existing TDE file, translation will fail.
- Drop and Create: Drop destination table if it exists, then create it. The writer will drop and re-create the table before writing any features to it. The table will be overwritten when the first input feature is processed. If no features are sent to a feature type, then the corresponding table will not be overwritten.
- Use Existing: Append to the existing table unless geometry is being written. If the file does not exist or geometry is being written, the translation will fail.
This parameter sets a table collation (or locale) to be used by the string columns. In Tableau, this can be seen under “Describe Field”, “Locale”. It controls string equality and string parsing, in particular date and numeric formatting in Tableau.
Internal Representation: Uses the system Region - Formats setting. In Windows, this is under Control Panel > Clock, Language and Region > Region > Formats tab.
Other options are: Arabic, Czech, Czech (Case-Insensitive), Czech (Case/Accent-Insensitive, Danish, German, English (Great Britain), English (US), English (US, Case-Insensitive), Spanish, Spanish (Case/Accent Insensitive), Estonian, Finnish, French (Canada), French (France), French (France, Case/Accent-Insensitive), Hebrew, Hungarian, Icelandic, Italian, Japanese (JIS), Korean, Lithuanian, Latvian, Dutch (Netherlands), Norwegian, Polish, Portuguese (Brazil), Portuguese (Brazil Case/Accent-Insensitive), Portuguese (Portugal), Russian, Slovenian, Swedish (Finland), Swedish (Sweden), Turkish, Ukrainian, Vietnamese, Chinese (Simplified, China), Chinese (Traditional, Taiwan)