Teradata Replication [message #646335] |
Sun, 27 December 2015 06:41 |
![](//www.gravatar.com/avatar/d1cc5a0c39337af5d17825f227eb0576?s=64&d=mm&r=g) |
anwaar
Messages: 1 Registered: December 2015 Location: india
|
Junior Member |
|
|
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.
|
|
|