DSXchange

I have 2 sequential file which will load into a single table.One is created from server job and other is created from parallel job.Both will contain same type of data.

I am having no issue loading to a table (via sql loader (oracle)) from the file which is created from server job but file which is created from parallel job has issues in loading the following data.

"abc"|""""Gunnado""""|"def"

Sequntial File Format in Parallel Edition:
Pipe delimited
Null Filed Value=""
Quote="


Sequntial File Format in Server Edition:
Delimiter=|
Quote Character="

Please help me in solving this issue..thanks

And the issue is?

Record is been rejected and the error is

"no terminator found after TERMINATED and ENCLOSED field"

And the example you posted:

"abc"|""""Gunnado""""|"def"

That is from the Server or PX generated file? What does the other one look like? Rather than assume, specificy for us which one loads and which one doesn't as well, please.