Hi everyone, Your expertise and recommendations are greatly appreciated for the below mentioned problem/issue.
I have exported huge amount of data in binary format using TPT script and compressed the exported file. I have sftp'd the binary file to external non teradata environment(Hadoop).
Problem Statement : I need to convert the binary exported file to ASCII before I store it in HDFS. Is there any tools,API's and any recommendations on how to convert the exported binary file(created by TPT script) to ASCII in non teradata environment ?
Once again your recommendations are greatly appreciated !!
https://github.com/xlfe/dwhwrapper is by far the cloest option you have.
TPT 14.** support CSV export as long as you come up the SQL to convert everything to VARCHAR/CHAR.