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

[iti-attunity-sup]

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

[aarun_arasu · Accepted solution]

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_Syb...

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

[iti-attunity-sup]

Thank you for your reply.
I understand about mapping.

I wait to hear from other experts a little.

Best Regards.