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
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What are the different design perspectives used in teradata?
What is a clique?
What is the use of stored procedures in teradata?
What are the functions of a teradata dba?
What are teradata utilities?
If RDBMS is halted what will you do ?
What is the difference between teradata and basic rdbms?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are aggregate tables? How do you design them using teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Highlight a few of the advantages that ETL tools have over Teradata.
Differentiate database data and data warehouse data?
What are the available primary index types?
How to eliminate product joins in a teradata sql query?