Interested to Buy Any Domain ? << Click Here >> for more details...
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 is meant by a Clique?
What are the design features involved in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is the difference between fastload and multiload?
List out some of the primary characteristics of teradata.
How do you do backup and recovery in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
why use references rather than pointers in the public api, particularly for arguments which are modified?
Can you fastexport a field, which is primary key by putting equality on that key?
Explain teradata utilities?
What is meant by a Parsing Engine?
Explain BYNET.
In general, how do you optimze any sql in teradata?
