 |
 |
Archives of the TeradataForum
Message Posted: Fri, 01 Jul 2011 @ 14:56:40 GMT
| Subj: | | Re: Multiset with a UPI |
| |
| From: | | Kartik Gulati1 |
John_Wight wrote:
| | A Multiset table with a unique constraint (i.e. UPI or USI) will be the same as a SET table with a unique constraint - i.e. No duplicate
row check. If you have a Multiset table, why would you apply a unique constraint? Maybe there is a good reason but (to date) I have not
identified any - but would be humbled to know if there was!!! | |
Hello John,
When I worked over at one of the GE accounts, it was a mandate to only use Multiset Tables. It was strongly recommended by consultants from
Teradata. So if we had to build a UPI we would build it over Multiset tables so yes you can find Multiset tables with UPI there :)
Regards
Kartik
| |
