3

I am doing replication from oracle to teradata where oracle is having below charter in one column. ->->-> ACSII value for this char is 26 . I need to replace it with null . In the charmap we have mentioned like:-

SOURCECHARSET AL32UTF8
TARGETCHARSET UTF-16
\xef\xbf\xbd  \x20

and included CHARMAP in the parameter file but do not know why this is not happening . I have to mannually update/insert the record in the teradata target Database each time when this collision happens .

Please let me know in case we can handle this automatically and prevent my replicat from ABEND.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.