Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
Thank you for your reply.
I understand about mapping.
I wait to hear from other experts a little.
Best Regards.