All Forums Tools
sachinace 11 posts Joined 09/07
16 Mar 2009
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

feinholz 1234 posts Joined 05/08
16 Mar 2009

FastExport does not support the output in delimtied format.

--SteveF

sachinace 11 posts Joined 09/07
18 Mar 2009

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

You must sign in to leave a comment.