When we use BYTES in Attunity task for teradata, tool has a limitation
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
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.
