Connector Improvement: Oracle NUMBER datatype conversion issue in HVR
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
-
Official comment
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. -
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.
Please sign in to leave a comment.
Comments
2 comments