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.
Slow loading
Moderators: chulett, rschirm, roy
Thanks for the quick response
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.
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?