Teradata enterprise stage

goutam · Post by **goutam** » Sat Aug 30, 2008 1:26 am

Can Teradata enterprise stage load a table having secondary index? In short does firstload utility support secondary index?

ray.wurlod · Post by **ray.wurlod** » Sat Aug 30, 2008 4:25 am

Firstload? Do you mean Fastload?

DS_FocusGroup · Post by **DS_FocusGroup** » Sun Aug 31, 2008 9:36 pm

No, Neither Fastload nor Multiload support secondary indexes. TPump is the only one that does.

toshea · Post by **toshea** » Tue Sep 02, 2008 5:14 pm

If possible, try using the Teradata Connector. You can load the table using the Immediate access method, and it will be faster than TPump or the Stream operator, since you can use arrays.