Best file format for TPUMP / Multiload

Tools & Utilities
N/A

Best file format for TPUMP / Multiload

Hi all, I am a beginner to Teradata here, I wonder if this question had been asked before, that is is there any best known format to be used for TPUMP and Multiload that will give some edge to the performance of both these TTUs?

Thanks
1 REPLY
Junior Contributor

Re: Best file format for TPUMP / Multiload

The best format is always internal Teradata format, because then there's no need for any data type conversion.

DATA in BTEQ
FORMAT FASTLOAD in MLoad/TPump/FExp

And if there are any NULLable columns use INDICDATA/INDICATORS.

Worst case is VARTEXT.

Dieter