Teradata insert Error due to Secondary Indexes
Posted: Fri Dec 15, 2006 12:46 am
Hi,
I am working on Datastage 7.5 Release and the Underlying OS is LINUX SUSE.
I am trying to insert a table X with some rows using Teradata Enterprise Stage. Table X has Primary Index and one Secondary Index defined on it.
While running the Job I am getting the below error.
NUN009_X: Table X has secondary indexes which must be removed.
on Database level we can insert into table X the data though there are secondary indexes but the same is giving problem when using Datastage.
Kindly help to resolve this issue.
regards,
I am working on Datastage 7.5 Release and the Underlying OS is LINUX SUSE.
I am trying to insert a table X with some rows using Teradata Enterprise Stage. Table X has Primary Index and one Secondary Index defined on it.
While running the Job I am getting the below error.
NUN009_X: Table X has secondary indexes which must be removed.
on Database level we can insert into table X the data though there are secondary indexes but the same is giving problem when using Datastage.
Kindly help to resolve this issue.
regards,