Teradata insert Error due to Secondary Indexes

[saur_classic]

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,

[nishadkapadia]

Hi,

Are you able to insert into the same table using Fastload on the database?

Teradata Enterprise Stage uses Fastload followed by Insert..Select statement.

Fastload does not support Secondary Indexes in Teradata.

IMHO,
Nishad