TDE Writer Feature Type Parameters
To access feature type parameters, click the gear icon on a feature type in the workspace to open the Feature Type Parameter Editor. To always display the editor in Workbench, you can select View > Windows > Parameter Editor.
General
All feature types share similar General parameters, which may include the Feature Type Name, Reader or Writer Name, and Geometry.
In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept a Table Qualifier prefix on the output table feature type.
See Editing Writer Feature Types for more information.
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)
Write Geometry
A comma-separated list of the geometry column names for writing.
Location columns will be created for each of the supplied geometry column names when creating a new table or matched against the existing geometry columns when writing to an existing table.
Note: If the column names listed here conflict with any user attributes, the columns listed here take precedence.