SQL Loader utility get used when Oracle Enterprise stage used with Load option. It helps uploading bulk data in the database. DataStage creates a control file based on the metadata from the input link. DataStage also creates bad file. If SQL Loader is not installed into the server then OCI generates error when used with Load option. SQL Loader come with Oracle client hence explicit installation is not required.
SQL Loader utility get used when Oracle Enterprise stage used with Load option. It helps uploading bulk data in the database. DataStage creates a control file based on the metadata from the input link. DataStage also creates bad file. If SQL Loader is not installed into the server then OCI generates error when used with Load option. SQL Loader come with Oracle client hence explicit installation is not required.
ReplyDelete