DSXchange

Hi

Is any one help me in knowing where the OCI Bulk loader store the control and data file when we are using automatic option.

I wants to know the path of control and data file.

Thanks in advance

From what I recall - wherever you tell it to put it. It's a property in the stage.

If you are using the stage called "Oracle OCI Load", it doesn't use SQL*Loader in Automatic Mode, so there is no Control file. OCI (Oracle Call Interface) provides a programatic direct-path interface that allows DS to link the load code directly into the plugin.

I have another stage called "Oracle 7 Load" - I don't know how this one works, but I don't use it.

Hi

When in automatic mode control file is not created. Automatic mode establishes connection with the database and populates the data from the source to the database.

It creates control file only in the manual mode where the data is not populated to the database and control file is created.

--Balaji S.R