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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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