Oracle Bulk loader
Posted: Thu Nov 13, 2003 12:00 pm
-----Original Message-----
From: Tom@KnowledgeNetCo.com [mailto:Tom@KnowledgeNetCo.com]
Sent: Sunday, October 12, 2003 3:39 AM
To: datastage-users@oliver.com
Subject: Oracle Bulk loader
Hi PPL,
Can someone tell me what the difference is between the OraBulk stage and
the OraOCIBL stage and which one to use when?
I cannot find a pdf on the OraBulk stage on the cd, so I cannot tell the
difference between the two. It does seem weird to have two stage to
accomplish the same thing...besides the fact that the OraBulk stage does
not allow one to sepcify basic connection options like dbname/username etc.
I assume it's only used for creating a .ctl and .dat file to be loaded
manually into Oracle.
We want to use a bulk loader to load Oracle 9i siiting on a Win2k machine
from our DS 6 server sitting on the same machine.
Thanks,
Tom.
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .
From: Tom@KnowledgeNetCo.com [mailto:Tom@KnowledgeNetCo.com]
Sent: Sunday, October 12, 2003 3:39 AM
To: datastage-users@oliver.com
Subject: Oracle Bulk loader
Hi PPL,
Can someone tell me what the difference is between the OraBulk stage and
the OraOCIBL stage and which one to use when?
I cannot find a pdf on the OraBulk stage on the cd, so I cannot tell the
difference between the two. It does seem weird to have two stage to
accomplish the same thing...besides the fact that the OraBulk stage does
not allow one to sepcify basic connection options like dbname/username etc.
I assume it's only used for creating a .ctl and .dat file to be loaded
manually into Oracle.
We want to use a bulk loader to load Oracle 9i siiting on a Win2k machine
from our DS 6 server sitting on the same machine.
Thanks,
Tom.
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .