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
Comment whether bottleneck is an error or not.
What is teradata?
What is the purpose of upsert command?
Highlight the advantages of PPI(Partition Primary Index).
What are the things to be considered while creating secondary index?
How to find duplicates in a table?
What are the various etl tools in the market?
What is real time and near real time data warehousing?
What are teradata utilities?
What is the opening step in basic teradata query script?
Explain the types of join supports by teradata?
What is smp and mpp platforms?
Explain BYNET.
What do you mean by parsing?
any one answer me how they can analyzing the project using data ware housing?