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,
Teradata insert Error due to Secondary Indexes
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Tue Aug 01, 2006 9:43 pm
-
- Charter Member
- Posts: 47
- Joined: Fri Mar 18, 2005 5:59 am
Re: Teradata insert Error due to Secondary Indexes
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
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