Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 24 Jan 2001 @ 17:41:54 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: FastLoad: Discarding Duplicate Rows
From:   Frank Martinez

Anybody want to take a poll? My vote is leave it that way. I've used Multiset tables, as well as tables with duplicate rows in other databases. In order to change, delete or even read ONLY ONE of those rows, it requires:

A) Knowing the ^%&$&% rowid and working with rowid, or

B) Reading all the dups, deleting all of them and then either putting back all the "others" you want (the delete option) or updating the one you want and writing it and all it's brothers.

And all this for what? Because someone hasn't adequately defined the table, ultimately!

Ok, I'm done ranting.


Frank C. Martinez IV

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020