Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When retrieving a schema from a database, the Talend Type Mapping Files are used to convert the database data types to Java data types, and I can adjust these to suit my project. But there are unexpected behaviors such that it seems that there must be some hard coding going on behind the scenes. For example, in the AS400 mapping file, NUMERIC is mapped by default to Float, but sometimes comes through as Integer (if the decimal positions is 0). This does not happen with DECIMAL. It almost appears that the Type Mapping files are not the only thing involved. But maybe there is something in there. Are there any documents telling what the properties and attributes mean in these files?
Hi, i hope this documentation can help you :
https://help.talend.com/r/QrWkwPvKmKybs~JNLeBt3Q/WkirlPeHHQnaQ1oJRSXuWg
Hello,
Here is Talend type mapping enhancement.
You can now set the default pattern for each date type in Talend type mapping file. This allows the date pattern for the date type columns to be set automatically when retrieving or guessing schema from a table.
Best regards
Sabrina