Archives of the TeradataForum

Message Posted: Wed, 01 Sep 2004 @ 14:12:19 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Thank you every one for your input. I think its our Data center standard to use pipe delimeted flat file. I will try to discuss with my team and try to come up with some other delimeter. The pipe with in the data that I was talking about did not put by FastExport. Instead it exists in the data, which actually should have been cleansed before arriving to our teradata box. We are trying to trace that back and see why is that happening. With Fast Export I have seen many unneccessary characters putting in the flat file. I had to trim and cast each data field and use mode Record to get a clean data. Our option to choose Fast Export is because of its speed. I am not very familiar with BTEQ. Can anyone enlighten me on the speed issues and clean data issues between FastExport and BTEQ. These scripts are going to pull about 30 mil rows of volume with a rowsize of 250

Thanks

Sree

	<Prev	Next>		<<First	<Prev	Next>	Last>>