Answer Posted / yogi
Identity column is used in tables to get the unique
values.Values of the attribute is stored in DBC.idcol. If
ALWAYS and NO CYCLE option is used, then duplicate values
would be avoided.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the primary index in teradata?
List out all forms of LOCKS that are available in Teradata.
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is meant by a Clique?
Why is the case expression used in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
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?
Explain the term 'primary key' related to relational database management system?
How is MLOAD Client System restarted after execution?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Explain the most common data types used in teradata?
Explain fallback in teradata?
Steps to create a data model?
What are the various reporting tools in the market?