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
How you will check the version of teradata?
What is called partitioned primary index (ppi)?
Highlight the advantages of PPI(Partition Primary Index).
How to select first n records in teradata?
If RDBMS is halted what will you do ?
Explain PDE.
What is spool space? Why do you get spool space errors?
Explain amp in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What do you mean by caching in teradata?
What is the purpose of using case expression in teradata?
What is a dimension table?
How would you load a very large file in teradata in general?
What are the 5 phases in a multiload utility?
