Truncating Data when Replicating Numeric Field from Oracle to Postgres

[QlikAdmin1234]

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

[Dana_Baldwin]

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

[DesmondWOO]

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:

1. Qlik Replicate version
2. DDL of the source table and target table
3. Sample data

Regards,
Desmond

[WLYB]

Dear all,

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

Thank you in advance.