topic Re: Truncating Data when Replicating Numeric Field from Oracle to Postgres in Qlik Replicate

Truncating Data when Replicating Numeric Field from Oracle to Postgres

QlikAdmin1234 — Mon, 06 Jan 2025 21:32:03 GMT

I am trying to replicate the Oracle data to the Target Database Postgres using Qlik Replicate. When I try to replicate numeric field from Oracle to Postgres, it is truncating the Decimal values. When I transformed the data time within the settings from numeric(10,0) to numeric (10,2) as well it is just replacing the decimal values to 00 rather than replicating the original source values. Any thoughts on how I can resolve it issue

Re: Truncating Data when Replicating Numeric Field from Oracle to Postgres

Dana_Baldwin — Mon, 06 Jan 2025 22:37:16 GMT

Hi @QlikAdmin1234

On the Oracle source endpoint, Advance tab, please set "expose number as" accordingly:

Expose NUMBER as: Select one of the following:
- A precision-scale combination
- FLOAT
- VARCHAR
Information note
- If precision is 39 or greater, select VARCHAR
- By default, the NUMBER data type is converted to precision 38, scale 10
- The "Expose NUMBER" definition in the Oracle database is used for the NUMBER data type only (without the explicit precision and scale definition)
Is Replicate creating the table on the target when the task runs?

What is the data type and precision on the target table for this column?

Thanks,

Dana

Re: Truncating Data when Replicating Numeric Field from Oracle to Postgres

DesmondWOO — Tue, 07 Jan 2025 02:56:07 GMT

Hi @QlikAdmin1234 ,

I did a quick test with the following tables.

Source: Oracle Table

CREATE TABLE DES.NUM1 (ID NUMBER(5) NOT NULL PRIMARY KEY, C1 NUMERIC(10,0));
INSERT INTO DES.NUM1 VALUES (1, 123);
COMMIT;

Target: PostgreSQL Table

CREATE TABLE "DES"."NUM1" (
"ID" int4 NOT NULL,
"C1" numeric(10, 2) NULL,
CONSTRAINT "NUM1_pkey" PRIMARY KEY ("ID")
);

I am unable to reproduce the problem with Full Load and CDC. Please provide:

Qlik Replicate version
DDL of the source table and target table
Sample data

Regards,
Desmond

Re: Truncating Data when Replicating Numeric Field from Oracle to Postgres

WLYB — Sat, 19 Jul 2025 07:43:26 GMT

Dear all,

Could someone please share the solution related to the reported problem?

Thank you in advance.