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
List out teradata data types?
How to identify ppi columns?
What is bteq utility in teradata?
What exactly do you know about catching in teradata?
What is a three-tier data warehouse?
Highlight a few of the advantages that ETL tools have over Teradata.
How many tables can you join in v2r5?
What are the available primary index types?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is dimensional modeling?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Syntax for case when statement?
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?
What are the string manipulation operators and functions associated with teradata?
Can we collect statistics on table level?