Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
Labels (2)
1 Reply
Anonymous
Not applicable
Author

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