Re: How do we generate surrogate keys in teradata ?
beware with identity columns. they will always generate unique values but not sequential. so there would be gaps in numbers. best approach would be to increment the surrogate key in your transform script which is a standard data warehousing practice and not limited to teradata. there is no teradata equivalent of oracle sequences which is used by OLTP systems to generate their keys mostly.