Skip to main content

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jdhruva
Contributor II
Contributor II

How to handle data type conversion

Experts need your guidance here. We are migrating from Oracle to Snowflake using QLIK. Part of the replication process we noticed that columns with datatype Number(20,2) in Oracle is transformed into Number(22) in Snowflake using QLIK. Data after the decimal is truncated in snowflake after a full/CDC load. Can you please help us fix this issue? Is there is a setting we need to configure to handle this transformation?

Labels (2)
13 Replies
SwathiPulagam
Support
Support

Hi @jdhruva,

 

This is not the expected behavior. I just tested and it is transferring the same datatype as it is in Oracle.

Example: Oracle source datatype Number(38,0)

Snowflake also same Number(38,0)

 

Thanks,

Swathi

SwathiPulagam
Support
Support

Hi @jdhruva,

 

I would recommend you to create a support case for doing more analysis.

 

Thanks,

Swathi

shashi_holla
Support
Support

Hi @jdhruva 

In addition to what @SwathiPulagam said, as per the documentation the behavior that you mentioned can happen only when the scale is between 38 and 127 else it will match the same data type as in the source Oracle. In your case is Number(20,2) should be the same in the target as well.

shashi_holla_0-1662756806446.png

 

jdhruva
Contributor II
Contributor II
Author

Hello Swathi, We I guess the team has already submitted a case. Here is another example, where the conversion didn't happen the right way (Refer Attached Screenshot; it is comparison between SNowflake and Oracle after a full load.QLIK-COMPARE.PNGLeft column is Snowflake and Right column is Oracle)

 

 

SwathiPulagam
Support
Support

Hi @jdhruva ,

 

Can you share the case number?

 

Thanks,

Swathi

SwathiPulagam
Support
Support

Hi @jdhruva ,

 

Also please check if you enable any Global transformation to convert the datatype.

 

Thanks,

Swathi

jdhruva
Contributor II
Contributor II
Author

Yes we have global transformation configured NUMERIC to 15,0

jdhruva
Contributor II
Contributor II
Author

case# 00051525

jdhruva
Contributor II
Contributor II
Author

Thanks Shashi. I assume this is already defined QLIK by default