idea From now on, please track this idea from the Ideation por... in Suggest an Idea

When we use BYTES in Attunity task for teradata, tool has a limitation

vvitta2016 — Mon, 20 Jul 2020 13:59:58 GMT

Hello, In a Db2 z/os source and Teradata target task we see that when we use BYTES column, rows are applied to target table by 'one-by-one' method, and it is not using bulk/batch-apply.

When we have contacted support team we got to know that it is a documented replicate tool limitation.

After further discussion, we got to know that this was a limitation as teradata might not have a function (when replicate tool was developed) to cast byte data to string, when data is moved to TEMP table. Currently, when we contacted Teradata vendor, and they said that there are functions in Teradata to cast BYTES data to STRING (VICE-VERSA) - function name - TO_BYTES/FROM_BYTES.

This request is to integrate these functions within tool or provide some option where we can use replicate tool to move BYTES data in batch mode or bulk mode. As our jobs are unable to keep-up latency with one-by-one mode.

For more information please refer this case# 01982849

Re: When we use BYTES in Attunity task for teradata, tool has a limitation - Status changed to: Open - Collecting Feedback

Ola_Mayer — Mon, 27 Jul 2020 12:38:40 GMT

Re: When we use BYTES in Attunity task for teradata, tool has a limitation - Status changed to: Open - In Development

Ola_Mayer — Fri, 31 Jul 2020 13:42:45 GMT

this issue was identified as a bug and being worked now by R&D

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 16:44:17 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: When we use BYTES in Attunity task for teradata, tool has a limitation - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:44:19 GMT