Archives of the TeradataForum

Message Posted: Fri, 30 Nov 2007 @ 14:30:29 GMT

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

One of the worst issue with IDENTITY is that you cannot just move tables from development to test environment: they must be rewrited.

In several projects we use a separate metadata area called "surrogate key mapping" with tables for all source-to-target key's relation stored. It works not as fast as IDENTITY, but it allows to recover surrogate keys for the same rows and to remove duplicates when data are coming from several data sources.

Best regards

Eugeniy Ostrovskiy
Teradata Professional Service Consultant

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