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
Issues with quotes during loading with bulk script
Moderators: chulett, rschirm, roy