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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you connect multiload from ab initio?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is meant by a Least Cost Plan?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
how do you manage the production space. what are the proactive methods you can take ?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
List out all forms of LOCKS that are available in Teradata.
Explain and compare pros and cons of start schemas?
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 is meant by a node?
What is teradata? What are some primary characteristics of teradata?
List out some of the primary characteristics of teradata.
what is object level locking ? where do appear this type of locking ?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is the use of having index on table?
