Fast Export Binary Format file - Binary to ASCII conversion and load in HDFS

Tools

Fast Export Binary Format file - Binary to ASCII conversion and load in HDFS

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 !!

2 REPLIES

Re: Fast Export Binary Format file - Binary to ASCII conversion and load in HDFS

Me to same question.. kinly reply us.

Enthusiast

Re: Fast Export Binary Format file - Binary to ASCII conversion and load in HDFS

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.