Talend community forum / How to make Retrieve Schema map DECIMAL field as BigDecimal instead of

fmcypriano · 2010-01-07 20:10:04

Tags: [BigDecimal, firebird, float, mapping, precision]

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.

cantoine · 2010-01-07 21:13:37

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

Announcement

Unanswered posts

#1 2010-01-07 20:10:04

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

#2 2010-01-07 21:13:37

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

Board footer