You can set the parameters for type conversion in Talend Studio, from Java towards databases and vice versa.
On the toolbar of the Studio main window, click
or click File > Edit Project Properties from the menu bar to open the [Project Settings] dialog box.
In the tree view of the dialog box, expand General and select Metadata of Talend Type to open the relevant view.
The Metadata Mapping File area lists the XML files that hold the conversion parameters for each database type used in Talend Studio.
You can import, export, or delete any of the conversion files by clicking Import, Export or Remove respectively.
You can modify any of the conversion files according to your needs by by selecting the file and clicking the Edit button to open the [Edit mapping file] dialog box and then modify the XML code directly in the open dialog box.
Using attributes in the conversion mappings, you can define the default values or
behavior of the relevant schema columns. The table below describes the frequently used
attributes in the dbType
element.
Attribute |
Description |
---|---|
ignoreLen |
When set to true, the length that you set for newly added columns of the type in schema (by Edit schema) on components will be ignored. |
ignorePre |
When set true, the precision that you set for newly added columns of the type in schema (by Edit schema) on components will be ignored. |
default |
When set true, the type defined in this element will be the default type of newly added columns (by Edit schema) on components. |
defaultLength |
Sets the default length of newly added columns of the type (by Edit schema) on components. |
defaultPrecision |
Sets the default precision of newly added columns of the type (by Edit schema) on components. |