Error table is getting loaded with error code "6706" while doing TPT EXTRACT/LOAD using TPT Binary Mode.
In case of text mode I understand we need to handle this case.
even for BINARY mode also do we handle this case.?
Yes. Record format BINARY only describes the output / input file to Data Connector. The Schema still describes the data as character for Load.
As Fred mentioned, the term "Binary Mode" only refers to the format of the data located in a flat file.
When you use the term "TPT EXTRACT/LOAD", I interpret that to mean you are extracting data from a database and then loading into Teradata.
What is the source of your data?
Can you provide your script?