OPTIMIZATION

karry450 · Post by **karry450** » Thu Feb 07, 2008 11:56 pm

Hi Friends,

I am running a server job in which my source is flatfile and target is oracle.

I have tried normal loading and bulk loading in which normal loading is faster than bulk loading.

Is there anyother way where i can increase the speed of loading records and performance also.

Can anyone suggest me please.

Thanks and regards

ray.wurlod · Post by **ray.wurlod** » Fri Feb 08, 2008 12:17 am

Define "performance" in an ETL context.

Try writing to a text file, and using a customized sqlldr control file to load into Oracle from that. For example, get the buffer sizes right (rather than defaulting to 256 for every field), use parallel load capabilities, and so on.

karry450 · Post by **karry450** » Fri Feb 08, 2008 12:24 am

ray.wurlod wrote:Define "performance" in an ETL context.

Try writing to a text file, and using a customized sqlldr control file to load into Oracle from that. For example, get the buffer sizes right (rather than d ...

Thanks , I have tried selecting Inprocess and defining some buffer 128 and tried this way, it is bit faster than normal loading.

But is there? any other way which gives lot of difference.

Thanks.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 08, 2008 3:06 am

Yes, the way I suggested.

Premium membership is one of the ways that the hosting and bandwidth costs incurred by DSXchange are met. At less than 30c (Rs12) per day, it is definitely a worthwhile investment for anyone claiming to be a DataStage practitioner.

kcbland · Post by **kcbland** » Fri Feb 08, 2008 9:14 am

DIRECT path or CONVENTIONAL? Lots of indexes or none? Triggers? Partitioned table? There are so many factors. Please narrow your question and describe the table and method of load.

chulett · Post by **chulett** » Fri Feb 08, 2008 9:16 am

Not sure why people seem loath to do this, but go have a chat with your DBA. They LOVE helping with stuff like this.

OPTIMIZATION

OPTIMIZATION

Optimization