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.
... View more