Fast Export & Fast loading

Tools
Enthusiast

Fast Export & Fast loading

Hi
In UNIX, I have fast exported 10 rows from source table(2 columns--item_id, site_id) to dw_abc(text format).

For eg: .export outfile dw_abc format text; ** this is the syntax i have used.
-------
10 rows got exported, but the problem is when i was opened the output file "dw_abc" in UNIX. It was showing like this.

item_id site_id
100 200
300 400
500 600
700800 ------------- item_id, site_id were not separated
900 1000
101201-------------item_id, site_id were not separated
301 401
501601-------------item_id, site_id were not separated
701 801
901 1001
Some of the item_id, site_id got separted by tab as a delimiter. Some item_id, site_id's were not separted. I want, all the item_id, site_id should be separated by tab as a delimiter.
Can anyone explain?

Thanks for ur support!!!

Thanks,
Guru
2 REPLIES
Teradata Employee

Re: Fast Export & Fast loading

FastExport does not support the exporting of data in delimited format.
I am sure that the column values were not separated by TAB whitespace characters.
TEXT format just writes the data in a format that comprises of the column data followed by end-of-record marker (newline).
-- SteveF
Enthusiast

Re: Fast Export & Fast loading

I would use delimeter in the fastexport select statement itself as follows.

select item_id,',',item_code
from Table....