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.
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