SESSION PASS THROUGH for Target end point (Teradata)
Hello ,
In Replicate, when special characters are present in source and cannot be copied to Target, during CDC the task is failing (Teradata). Each character has to mentioned to replace it. This will work out good if we can identify the characters. Since it is very difficult to identify upfront,
Teradata DBA provided this syntax to use at the client.
TPT syntax to enable UPT: VARCHAR UnicodePassThrough = 'ON',
Proposing that in GUI / as additional parameter, user should have capability to provide above parameter so that session pass through can happen.
Also the information about the record should be recorded in log/error table.
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.