topic unexpected decimal truncation in Qlik Replicate

unexpected decimal truncation

Ayman1 — Thu, 06 Jan 2022 18:46:08 GMT

Hello all,

I'm still new to Qlik replica product “Attunity” and was looking for support on a unexpected decimal truncation that occurs after the data is loaded at the target database.

We pull data from and Oracle database where the column that we are facing an issue with is a decimal (18,2) ex:[35.25] and it shows in the correct format in the Oracle source table.

we built a task in attunity to replicate to a target database “Snowflake” and the result seems to truncate the two decimal points ex:[35.00] for all values.

We are currently running on a 2021.5. version. this was not an issue in the previous version that we had. Can I please get some guidance on how to solve this issue?

Re: unexpected decimal truncation

Heinvandenheuvel — Fri, 07 Jan 2022 01:55:11 GMT

So what is the datatype on target, can you 'describe' the table there?

How was the target table created? Was Replicate allowed to (drop and) create?

Maybe there is something in the task or endpoint json. Can you share that (remove excess explicit tables)

When you 'manually' - outside Replicate - store a row with decimal value into the Snowflake target table, how does it look like coming back on a select?

hth,

Hein

Re: unexpected decimal truncation

Ayman1 — Fri, 07 Jan 2022 17:38:26 GMT

Hi Hein,

Thank you for response.

So what is the datatype on target, can you 'describe' the table there?

the snowflake target uses a Transient table And the field that we are having an issue with has a data type of NUMBER(18,4)

How was the target table created? Was Replicate allowed to (drop and) create?

Attunity created the table

Maybe there is something in the task or endpoint json. Can you share that (remove excess explicit tables)

Not sure how to answer this question. still new to this tool.

When you 'manually' - outside Replicate - store a row with decimal value into the Snowflake target table, how does it look like coming back on a select?

When I use other ETL tools such as informatica to pull this data in it seems to work just fine . And we don't see the issue we're seeing with Attunity

Regards,

Ayman

Re: unexpected decimal truncation

Steve_Nguyen — Fri, 07 Jan 2022 17:52:56 GMT

1. could you check what is your oracle endpoint / advanced tab / Expose NUMBER as: what is this set for ?

2. if you change the Expose NUMBER as: to varchar, and reload the table, what is the value , on the target ?