3335224 - Data type mismatch while using Table Replicator operator with source Oracle NUMBER type column

When using Table Replicator to replicate data from Oracle to ADL, when there is NUMBER type columns in source Oracle table and the output data format on ADL is parquet, in target ADL parquet file the data type for the columns differs from time to time.

e.g. Replicating a table with a number(5) column in Oracle results in the target initial load file having INTEGER as it's type, and the deltas will have DECIMAL(38, 7).

SAP Data Intelligence onPrem 3.3.7

KBA , CA-DI-IS-FA , Flow Agent , CA-DI , Data Intelligence , Problem