Pipeline "copy data" activities built against and Oracle source with a Fabric warehouse target do not handle precise decimal values correctly.
For example, an Oracle NUMBER(3,2) should be able to copy to a Fabric warehouse decimal(3,2) without issue, but because of the intermediate staging to Parquet format, we get an error:
ErrorCode=DWCopyCommandOperationFailed,
'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,
Message='DataWarehouse' Copy Command operation failed with error 'Column 'the column name' of type 'DECIMAL(9, 3)' is not compatible with external data type 'Parquet physical type: DOUBLE', please try with 'FLOAT'.
We would expect the data to be staged to a Parquet DECIMAL type and convert correctly into the Fabric warehouse.
