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
Explain the term 'row' related to relational database management system?
Comment whether bottleneck is an error or not.
What tools would you use for that?
What is the meaning of Caching in Teradata?
Can we collect statistics on multiple columns?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is a three-tier data warehouse?
What is bteq utility in teradata?
What are the uses of bynets in multi-node systems?
Different phases of multiload?
Describe primary index in teradata. And what are the available primary index types?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is the multi-insert?
What is the maximum number of dml can be coded in a multiload script?
What is the purpose of upsert command?