DSXchange

Hi Friends,

I am loading the target (oracle) from a flat file using ORACLE OCI BULK but before loading I want truncate the target table. But there is no option to delete or truncate the table before loading in ORACLE OCI BULK stage. Can anyone help me with alternate way without creating one more job for truncating the table.

replace

Replace is not the same as truncate. Google for 'oracle sqlldr truncate'. I don't believe the truncate option is supported through the GUI, you may need to do it as a separate step.

In Before job sub routine calls the shell script. in side the shell script call delete statement.