Archives of the TeradataForum
Message Posted: Thu, 11 Jun 2009 @ 15:10:21 GMT
| Subj: | | Re: Doubts Regarding TD Utilities |
| |
| From: | | Michael Larkins |
Hardeep Singh Arora:
| | 1. Why FastLoad Doesn't load duplicate rows into a MULTISET table? | |
- it has a very primative restart logic. Duplicates (like in MULTIDET) is assumed to be a record that was sent two timess. Therefore, when
phase II starts, it sorts all the work rows. When it finds duplicates, it throughs away all but one. It was written to use a USI/non-multi-set
table.
| | 2. Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table? | |
- This is wrong. MLOAD can load either USI or UNSI (SET or MULTISET tables). Not sure where you are getting your info, but it is wrong.
The only restriction regarding a table with a NUSI is a Paritioned table where the partitioning column is not part of the PI. This when the
table must have NUSI. It has nothing to do with MLOAD.
regards,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| 
