Archives of the TeradataForum

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

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

<-- 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>>