Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

Tools
Enthusiast

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
2 REPLIES
Enthusiast

Re: Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

This was answered in another thread:

http://www.teradata.com/teradataforum/Topic14439-9-1.aspx
Enthusiast

Re: Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

Multiload builds a separate NUSI change row to be applied to each NUSI subtable after all of the rows have been applied to the primary table. Hence...but this is not advisable because it degrades performance.