Fastexport Format - For a comma sepated or a fixed width fiile

Tools & Utilities
Enthusiast

Fastexport Format - For a comma sepated or a fixed width fiile

Hi -

I need to generate a flat file using fastexport for Informatica to read.

Teradata ---> Using fexp - Flat File ---> SQL SERVER load using Informatica.

I need a fixed width or comma separated file.What should be the format of my fasexport script ?

MODE RECORD FORMAT ? ;

? = UNFORMAT , TEXT , FASTLOAD , BINARY or any other specification with this .

Thank you

2 REPLIES
Teradata Employee

Re: Fastexport Format - For a comma sepated or a fixed width fiile

FastExport does not support the output in delimtied format.
-- SteveF
Enthusiast

Re: Fastexport Format - For a comma sepated or a fixed width fiile

I have generated the deliminited flat file by concatenating ',' in the select itself.

Thanks !!