Answer Posted / yuvaevergreen
Identity columns are system generated values. Generally
these columns are used for unique values. Some restrictions are
1. Only 1 column can be specified as identity column.
2. PPIs, Join indexes, hash indexes cannot have identity
columns as indexes.
3."Default" and "Always with cycle" option in identity
columns may result in duplicates.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are differences between teradata and ansi session modes in teradata?
How is MLOAD Teradata Server restarted after execution?
In the Primary Index, what is the score of AMPs that are actively involved?
Explain the parallel data extension in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Highlight a few of the advantages that ETL tools have over Teradata.
What is meant by a dispatcher?
In general, how do you optimze any sql in teradata?
Comment whether bottleneck is an error or not.
what are the uses of fact table and dimension table in banking project?
What are the functions involved in shared information architecture?
What are the joins in teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is the opening step in basic teradata query script?
List out all forms of LOCKS that are available in Teradata.