which delimiter should i use

UDA
Enthusiast

which delimiter should i use

"Hi I am getting data from all over the World and with informatica i m creating the delimted files
but the problem is that the delimter i used it might have come in some of the filed of the files while loadin with TPUMP or FASTLOAD
I m fetching data ffrom oracle and loadin to the teradata
I tried to use some combination of the ASCII symbol as delimter informatica generating the file with that combination but TPUMP and FATLOAD dont consider more than one delimerter while loading.

ANY suggestion?
3 REPLIES
gg
Enthusiast

Re: which delimiter should i use

There is quite some discussion in the following thread. I'm pointing directly to the simple solution but there is still some risk that your separator will fail:
http://www.teradataforum.com/teradata/20061109_125307.htm
Enthusiast

Re: which delimiter should i use

whats the meaning of this

SET RECORD VARTEXT \ " \ x1F \ " ;
gg
Enthusiast

Re: which delimiter should i use

1F is a hex value which is defined as unit separator:

http://en.wikipedia.org/wiki/C0_and_C1_control_codes