Qlik Replicate: Numeric data precision from Oracle to AWS S3

[Alan_Wang]

The Oracle as a source endpoint Number data type precision is selected with the endpoint settings "Expose NUMBER as:". Default conversion is precision 38, scale 10. This may affect numeric data types in certain endpoints if the source record is larger than a precision of 38. Records that are not interpreted correctly will end up with a value of 0.0000000000 in the target (precision 38, scale 10).

Environment

• Qlik Replicate  
• Oracle as source endpoint and Amazon AWS S3 bucket as target endpoint

Resolution

The VARCHAR option will need to be selected for the Oracle endpoint setting "Expose NUMBER as:" so the target can interpret records larger than a precision of 38. 

Cause

Certain target endpoints are not able to interpret Number data types that were defined without precision and scale from the source which Replicate will expose as the precision and scale defined in the Oracle as a source endpoint settings.

Related Content

Setting advanced connection properties - Oracle