I am facing the following issues while loading UTF8 files.
hI guys, Unable to pass Character Set encoding to TPT: In order to load UTF8 data to Teradata table, we need an attribute/option in tTeradataTptUtility or tTeradataTPTExec job that results in “USING CHARACTER SET UTF8” in the generated script. There is an option on the “Advanced SettingsàDefine Character set” which is used by Talend to execute tbuild with –e flag. However, it is of no use to us it specify the character set encoding of script file i.e. if script file is generated in UTF8 or ASCII then one can specify its encoding. While, we need the Teradata session character set encoding in order to load Arabic data to Teradata table with Unicode columns.