Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW

The number data on the Oracle source landing with .0000000000 extension on the postgresql target, but there is no extension on the source

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Dana_Baldwin
Support
Support

The number data on the Oracle source landing with .0000000000 extension on the postgresql target, but there is no extension on the source

Last Update:

Feb 4, 2022 6:51:34 PM

Updated By:

Dana_Baldwin

Created date:

Feb 4, 2022 6:51:34 PM

The numbers being padded with additional zeros should be resolved by changing the "Expose NUMBER as:" setting on the Advanced tab of the source endpoint. Change that to VARCHAR and test to confirm. The value will be cast back to a number on the target.

Environment

  • Replicate 7.0.0.797

Cause

By default, Oracle source endpoints are set to expose numbers as NUMERIC(38,10)

Related Content

https://community.oracle.com/tech/developers/discussion/2578171/largest-number-of-digits-for-number-...

Labels (2)
Comments
akaradhya
Partner - Contributor II
Partner - Contributor II

I am facing the same issue. Is there a workaround for this issue?

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @akaradhya 

If the workaround mentioned in this article does not achieve the desired results, I recommend posting your query directly in our Qlik Replicate forum to make use of the wider reach into our community and our active support engineers. Feel free to refer back to this article as an example of what you tried.

All the best,
Sonja 

Contributors
Version history
Last update:
‎2022-02-04 06:51 PM
Updated by: