How to create control files for oracle bulk loader

femil · Post by **femil** » Tue Nov 03, 2009 12:04 pm

how to create a control file and data file if i use oracle bulk load passive stage in my server job

Sreenivasulu · Post by **Sreenivasulu** » Tue Nov 03, 2009 12:07 pm

If i am not wrong you need datastage mentoring or training.

Regards
Sreeni

femil · Post by **femil** » Tue Nov 03, 2009 12:23 pm

Sreenivasulu wrote:If i am not wrong you need datastage mentoring or training.

Regards
Sreeni

i accept that, i am new to this tool and very much interested to explore it

chulett · Post by **chulett** » Tue Nov 03, 2009 12:27 pm

It creates everything for you... and there's no persistent 'data file' in the traditional sense, it uses a fifo pipe instead.

femil · Post by **femil** » Tue Nov 03, 2009 12:35 pm

chulett wrote:It creates everything for you... and there's no persistent 'data file' in the traditional sense, it uses a fifo pipe instead. ...

hi can you refer some url which explains how to create control files for bulk loader

chulett · Post by **chulett** » Tue Nov 03, 2009 1:31 pm

Sure... www.google.com with a suggested search string of 'sqlldr control file'.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 03, 2009 2:04 pm

DataStage will create the control and data files.

Sometimes you might like to create a custom control file separately from DataStage and just have DataStage create the data file. This is also an acceptable approach.