topic Re: [SAP Sybase ASE Source] How to replicate fractional seconds of time/bigtime data type. in Qlik Replicate

[SAP Sybase ASE Source] How to replicate fractional seconds of time/bigtime data type.

iti-attunity-sup — Fri, 08 Mar 2024 06:31:15 GMT

Hello

[Description]
My customer replicate data from SAP Sybase ASE to SAP Sybase ASE.
There are table which have TIME and BIGTIME datatype.
Qlik replicate truncate fractional seconds of these columns by FullLoad.

[Question]
Can Qlik Replicate replicate TIME and BIGTIME type data without truncate fractional seconds?
If yes , how to configure to do it?

Best Regards
Nakagawa

Re: [SAP Sybase ASE Source] How to replicate fractional seconds of time/bigtime data type.

aarun_arasu — Fri, 08 Mar 2024 06:40:25 GMT

Hello @iti-attunity-sup ,

Thanks for reaching out to Qlik community

Yes you are right , its is due to data mapping that happens in Qlik Replicate

Below is the user guide for your reference

https://help.qlik.com/en-US/replicate/November2023/Content/Replicate/Main/SAP%20Sybase%20ASE/SAP_Sybase_ASE_db_Source_Data_Types.htm#ar_sybaseds_2343061694_1631287

The Qlik replicate maps BIGTIME to TIME which will truncate the nano seconds.

But , I do not think there is a workaround , because these mappings happens internally and I believe by the time when the value reaches replicate it would have been already truncated.

But , lets wait to hear from other experts as well.

Regards

Arun

Re: [SAP Sybase ASE Source] How to replicate fractional seconds of time/bigtime data type.

iti-attunity-sup — Mon, 11 Mar 2024 01:13:37 GMT

Thank you for your reply.
I understand about mapping.

I wait to hear from other experts a little.

Best Regards.