what is identity columns in teradata
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is the process to restart the multiload if it fails?
What is oltp?
What does sleep function does in fast load?
Explain the meaning of Amp?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
What are teradata utilities?
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
what is use of PI(primary index) AND SI(secondary index)
Explain the parallel data extension in teradata?
What is the difference between global temporary tables and volatile temporary tables?
Explain teradata utilities. What is multiload, fast load, tpump?
in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that