Slow loading using DataStage with Teradata table as Target
Posted: Fri Apr 09, 2004 12:43 pm
Hi,
I have a simple mapping on datastage. I am loading data from a flat file (with 19 columns with about 500,000 rows)into single Teradata table through a transformer. I don't have any native stage driver for Teradata, hence using the ODBC stage to connect to teradata database. But it is taking more than 12 hours to complete the loading(computing about 6 rows/sec). I have dropped the Secondary Index from the target table and increase the rows per transaction in the ODBC stage.
I am not able to drop the primary Index on the table. I believe we cannot drop primary Indexes in teradata.
Is there a way to Increase the performance of this simple loading?
I will really appreciate any help?
Thanks
I have a simple mapping on datastage. I am loading data from a flat file (with 19 columns with about 500,000 rows)into single Teradata table through a transformer. I don't have any native stage driver for Teradata, hence using the ODBC stage to connect to teradata database. But it is taking more than 12 hours to complete the loading(computing about 6 rows/sec). I have dropped the Secondary Index from the target table and increase the rows per transaction in the ODBC stage.
I am not able to drop the primary Index on the table. I believe we cannot drop primary Indexes in teradata.
Is there a way to Increase the performance of this simple loading?
I will really appreciate any help?
Thanks