topic Re: Getting trailing zeroes in Qlik Replicate

Getting trailing zeroes

Manjunathps — Mon, 11 Mar 2024 10:31:49 GMT

Hi All,

I am doing a Full load from Oracle to KINESIS stream, in the date columns for a particular table, I am getting the extra 9 zeroes at the target in timestamp. the data type is DATETIME(0)

Ex: Oracle source : 08-02-2023 14:12:56 at the target it is: 08-02-2023 14:12:56.000000000

Any quick resolution is highly appreciated.

Thank you

Re: Getting trailing zeroes

SachinB — Mon, 11 Mar 2024 10:48:01 GMT

Hello @Manjunathps ,

Thank you for reaching out to the Qlik community!

Could you please try adding the global transformation as convert data type? And let us know the results for the same.

Regards,

Sachin B

Re: Getting trailing zeroes

Manjunathps — Mon, 11 Mar 2024 12:26:02 GMT

Hi @SachinB ,

I will check this and let you know.

Thank you,

Manjunath

Re: Getting trailing zeroes

Rishel — Mon, 11 Mar 2024 13:40:04 GMT

Consider applying a transformation to the datetime columns before they are loaded into the Kinesis stream. You can format the datetime values to match the desired format (without the additional zeroes) using Oracle's formatting functions.