I get the following error.
Teradata Parallel Transporter Version 14.10.00.10
I got it working by specifying table name after $INSERT macro. I didn't find this information in the user guide document. I had to try different options to get it working. SO the final script is
USING CHARACTER SET @v_utf