Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Oracle NUMBER datatype conversion issue in HVR

Arivumani Ramalingam User

The Oracle NUMBER datatype is automatically converted into NUMBER(38,4) in Snowflake destination tables.  This will add unwanted decimal point 0s to whole numbers. We don't want to see the unwanted decimal places unless specified by the user. Please take care of this request asap as it's a showstopper for all the Oracle sources.

Source Oracle DB->   "CURRENCY"  NUMBER,  => Value 1001

SF Target->  CURRENCY NUMBER(38,4) NOT NULL DEFAULT 0,  => Value 1001.0000

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Mark Van de Wiel User

    Hi Arivu,

    It is possible to use ColumnProperties action to implement this behavior. For all tables, for the group TARGET, define an action ColumnProperties using DatatypeMatch="number[prec=0 && scale=0]". For example you could map such filter to Datatype=integer8 in the ColumnProperties action.

    Hope this helps.
    Mark.

  • Mark Van de Wiel User

    Hi Arivu,

    You can use ColumnProperties action in LDP (HVR) to adjust the mapping. If you want to do this for all columns listed as NUMBER without scale or precision in Oracle then you can use DatatypeMatch. https://fivetran.com/docs/local-data-processing/action-reference/columnproperties#parameters

    Hope this helps.
    Mark.