DSXchange

Data from source is as follows.

a||metaway"insurance||b||c

When i am creating a sequential file of above data in server by specifying option quite character values as " data loks like below.

a||"metaway"insurance"||b||c

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


but in parallel edition the extra quotes were not inserted and hence it was rejected while loading to table.

a||metaway"insurance||b||c

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



How would we handle in parallel edition when these characters appears.

Thanks

Unfortunately, that's "the way things are". The parallel Sequential File stage is notorious for not handling embedded quote characters properly, as a Search through this forum will reveal. You can, of course, put your own quotes on and specify the Quote Character property as none, but it would have been so much nicer if the stages behaved the same way.