How to make Retrieve Schema map DECIMAL field as BigDecimal instead of

One Star

How to make Retrieve Schema map DECIMAL field as BigDecimal instead of

Hello,
I need to make the "Retrieve Schema" option map DECIMAL field as BigDecimal instead of Float, because with Float I've no precision even with Precision column setted on schema.
Is there a way to teach Talend the type I want to use or do I have to change each field manually?
I'm connecting to a Firebird database.
Employee

Re: How to make Retrieve Schema map DECIMAL field as BigDecimal instead of

Hi;
In the Talend properties (Menu : Window > Preferences) you have the capabilities to change/customize the DataType mapping when you retrieve Schema (Table definition).
In the preference : expand Talend and Specific settings and choose Metadata of TalendType.
You'll see the Databases list covered by talend, and the mapping_Firebird.xml.
Choose to edit this one and change the XML content to choose your favorite default type.
Go the the XML section <dbToTalendTypes>
and then change the node to have :
<dbType type="DECIMAL">
<talendType type="id_BigDecimal" default="true" />
<talendType type="id_Float" />
<talendType type="id_Double" />
</dbType>
Best regards