Slow loading

rkumar28 · Post by **rkumar28** » Mon Apr 12, 2004 9:33 am

Hello,

I am trying to directly load one teradata table from a flat file. There is no changes in data...I am just directly loading the flat file data into a one table with one transformer in between. I am using the ODBC to connect to the database.
But my loading session is very slow. In the monitor in DataStage director.... it shows me loading is taking place in <1 rows per second.

I tried stopping the job after 30 minutes. The monitor shows me it has loaded only 2000 rows but when I query the table...I don't see my rows in there. I am not sure what is exactly going on.

I will really appreciate any help in this regard.

chulett · Post by **chulett** » Mon Apr 12, 2004 9:53 am

Don't you already have a thread open on this subject?

kcbland · Post by **kcbland** » Mon Apr 12, 2004 10:00 am

What is your commit setting?

rkumar28 · Post by **rkumar28** » Mon Apr 12, 2004 3:30 pm

The commit interval is 200 and the parameter array size is 1. If I increase the parameter array size....I start getting the error at runtime.

I am Sorry to post this again. I am trying to figure this out for quite sometime through DataStage as my group is already using this tool for the DB2 load.

kcbland wrote:What is your commit setting?

DSXchange

Slow loading

Slow loading

Thanks for the quick response