Page 1 of 1

database OCI, Enterprise, CLI, Load, Load Express

Posted: Wed Jun 17, 2009 12:10 pm
by tostay2003
Hi,

For almost every database plugin we have OCI, Enterprise, CLI, Load, Load Express.

What are the differences between these stages. i.e. when to use them?

Load Express - This appears as a direct load in SQL loader. Am I right?

Thanks

Posted: Wed Jun 17, 2009 12:23 pm
by mandyli
Yes. You are right..

All the plug-in stage needs to use depend upon your requirements.

Better to use all native Enterprise stage is always good.

Posted: Wed Jun 17, 2009 12:32 pm
by tostay2003
mandyli wrote:Yes. You are right..

All the plug-in stage needs to use depend upon your requirements.

Better to use all native Enterprise stage is always good.

what are the others used for i.e. the oci, cli stages and again when to use load vs load express stage

Posted: Wed Jun 17, 2009 1:00 pm
by chulett
Those are going to be database specific stages, typically tied to the interface they are named after. OCI = Oracle Call Interface, CLI is for Informix and any 'Load' stage is usually a bulk load of some kind.

Posted: Wed Jun 17, 2009 4:24 pm
by ray.wurlod
Then, when you get to version 8, you will also have Connectors in the mix.