Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 11 Apr 2003 @ 19:13:55 GMT

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

Subj:   Re: How to implement the sequence concept in teradata
From:   Anomy Anom

<-- Anonymously Posted: Friday, April 11, 2003 14:19 -->

We had this scenario where we had to identify a subscriber based on his first name, last name and address_line_1. We did not have any other columns in the source database to uniquely identify the subscriber. Say this subscriber information is part of several transaction tables. Now, is it not a good idea to create a unique identifier (a system generated primary key) and use that identifier in the transaction tables rather than all the three cols (first name, last name and address_line_1). Here is where I see the need for a sequence number generator. Correct me if I am wrong.

Thank You.

  <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: 27 Dec 2016