DSXchange

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.

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

What is your commit setting?

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?