SAP Knowledge Base Article - Preview

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


SAP Data Intelligence 3.0


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.