what is identity columns in TD?

Answer Posted / yuvaevergreen

Identity column is a system generated value. Used for row
uniqueness. If rows need to be unique, then ALWAYS option
should be used with NO CYCLE option. Separate DBC table
takes care of identity columns DBC.idcol.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out teradata data types?

760


How to identify ppi columns?

880


What is bteq utility in teradata?

743


What exactly do you know about catching in teradata?

808


What is a three-tier data warehouse?

819


Highlight a few of the advantages that ETL tools have over Teradata.

868


How many tables can you join in v2r5?

820


What are the available primary index types?

929


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

813


What is dimensional modeling?

823


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3141


Syntax for case when statement?

824


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

1824


What are the string manipulation operators and functions associated with teradata?

848


Can we collect statistics on table level?

803