how change the quote used in OPTIONALLY ENCLOSED
Posted: Wed Jul 23, 2008 6:17 am
I am loading data from a SQL Server database into Oracle through a parallel job.
I have an ODS enterprise stage pointing to SQL Server, Transformer Stage, and finally a Oracle Enterprise stage with following settings:
Write Method: Load
Write Mode: append
My issue comes with the fact that in my data I have double quotes ("), single quotes ('), and commas (,). I have found where to change the delimiter in the APT_ORACLE_LOAD_DELIMITED variable to take care of the comma issue. However, it insist on using double quotes as string qualifier and adding OPTIONALLY ENCLOSED BY X'22' to the control file. This is causing lots of the data to error when it should not. where can i change the value of "OPTIONALLY ENCLOSED".
I have an ODS enterprise stage pointing to SQL Server, Transformer Stage, and finally a Oracle Enterprise stage with following settings:
Write Method: Load
Write Mode: append
My issue comes with the fact that in my data I have double quotes ("), single quotes ('), and commas (,). I have found where to change the delimiter in the APT_ORACLE_LOAD_DELIMITED variable to take care of the comma issue. However, it insist on using double quotes as string qualifier and adding OPTIONALLY ENCLOSED BY X'22' to the control file. This is causing lots of the data to error when it should not. where can i change the value of "OPTIONALLY ENCLOSED".