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