ORABULK and ORAOCIBL difference and when to use

Smeitei · Post by **Smeitei** » Thu Mar 01, 2007 1:47 pm

1. What is the difference between ORABULK & ORAOCIBL stage.
2. What is the best scenario in which to use to use this stages

Scenario in which i want it to use.
1. Unload data from Redbrick database (I am using an ODBC stage to unload record and it is working fine)
2. Load the unloaded data to Oracle database(oracle 9i).

Should I use ORABULK or ORAOCIBL stage.

chulett · Post by **chulett** » Thu Mar 01, 2007 2:27 pm

ORABULK is for Oracle 7, ORAOCIBL is for 8 (and up). Both are 'bulk loader' stage so use them (the latter, actually) when ever it is appropriate to bulk load the data.

Smeitei · Post by **Smeitei** » Thu Mar 01, 2007 2:48 pm

Thanks for the information . So for my scenario I should be using ORAOCIBL stage as I have to load it to Orcale 9i.

I am planning to have this design approach now.

ODBCstage -----> Transformer ------> ORAOCIBL stage

And in ORAOCIBL stage have a after job subroutine to invoke the sqlldr to load the Oracle table.

Will this design approach work out.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 01, 2007 3:22 pm

Review the properties of the ORAOCIBL stage carefully. Look for a property with "automatic" in its name.

Smeitei · Post by **Smeitei** » Fri Mar 02, 2007 11:13 am

What is the meaning of that automatic. Does it mean i have to just specify the target table and don't have to create Ctrtl file and data file to load it .

chulett · Post by **chulett** » Fri Mar 02, 2007 11:20 am

Basically, yes. Put your cursor in the 'Mode' field and click on 'Property Help'.

vpauls · Post by **vpauls** » Wed Mar 28, 2007 5:37 am

I,m sorry to step into this conversation but with automatic load in oracibil do you still need to use sqlldr or will the data be automatically put into the given table?

BR
/Elin

ray.wurlod · Post by **ray.wurlod** » Wed Mar 28, 2007 6:43 am

YOU don't need to use sqlldr in automatic mode, but the stage process does invoke sqlldr (automatically). The implications for Oracle client software and environment variables should therefore be apparent.

chulett · Post by **chulett** » Wed Mar 28, 2007 7:38 am

Technically, it doesn't 'invoke sqlldr' as in the command line function but instead hooks directly into the database via an API. This also means it does not generate the 'bad' or 'ctl' or 'dsc' logs you would normally be interested in.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 28, 2007 12:29 pm

... although sometimes you will get "log" and "logbad" files in /tmp.