GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Golden Gate truncating decimal places for number data type post migration

edited Jun 15, 2018 5:01AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Gurus,

We are migrating data from oracle to PostgreSQL using Golden Gate. We observed that for number data type golden gate truncated data in PostgreSQL after 6 decimal places. For e.g. a number 9999.1234567890 in oracle got converted to 9999.123456 in PostgreSQL after replication.  Here we are observing data loss.

In source oracle datatype of the column is number while in target PostgreSQL datatype of column is numeric.

I am assuming it is related to some setting at golden gate level. Does any of you observed and fixed this issue?

Thanks

Gaurav

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center