When processing data flows using a tMap, if the input and output columns across a mapping are of different data types, compiling errors may occur at the Job execution time. The Enable Auto-Conversion of types option in the tMap helps avoid such errors.
To enable this feature in tMap in a Job:
Click the button at the top of the Map Editor to open the [Property Settings] dialog box.
Select the Enable Auto-Conversion of types check box and then click OK.
You can activate the automatic conversion option at the project level so that any tMap component added afterwards in the project will have this feature enabled.
If needed, you can also define conversion rules to override the default conversion behavior of tMap.
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 Auto-Conversion of types to open the relevant view.
Select the Enable Auto-Conversion of types check box to activate the automatic type conversion feature for all tMap components added afterwards in the project.
If needed, click the [+] button to add a line, select the source and target data types, and define a Java function for data type conversion to create a conversion rule to override the default conversion behavior of tMap for data that matches the rule.
You can press Ctrl+Space in the Conversion Function field to access a list of available Java functions.
The rule shown in this example will match mappings with the input data type of String and output data type of Integer.
You can created as many conversion rules as you want.
Click Apply to apply your changes and then OK to close the dialog box.