Bulk load into Teradata
Posted: Fri Jun 27, 2014 4:35 am
Hi,
I have designed a job to pull the data from Oracle table and load into Teradata table.
As the source table has around 3 millions records, I have used BULK as access method in TD connector which is throwing the below error:
RDBMS code 3621: Cannot load table plan_demand_WT unless secondary indexes and join indexes are removed.
I'm able to load the data if I use immediate as access method which takes longer time for execution.
For analysis, I ran the below query and found no secondary/join index present in the work table
sel * from dbc.indices where databasename='Dev' and tablename='XX';
but there is a partitioned index present on a particular date column!!
Could anyone help me to resolve this issue? Am I getting this error because of petitioned index?
I have designed a job to pull the data from Oracle table and load into Teradata table.
As the source table has around 3 millions records, I have used BULK as access method in TD connector which is throwing the below error:
RDBMS code 3621: Cannot load table plan_demand_WT unless secondary indexes and join indexes are removed.
I'm able to load the data if I use immediate as access method which takes longer time for execution.
For analysis, I ran the below query and found no secondary/join index present in the work table
sel * from dbc.indices where databasename='Dev' and tablename='XX';
but there is a partitioned index present on a particular date column!!
Could anyone help me to resolve this issue? Am I getting this error because of petitioned index?