what is identity columns in TD?
Answers were Sorted based on User's Feedback
Answer / tdguy
Identity Columns are system generated numbers for every row
as it is inserted in the table.These columns ensure row
uniqueness in a table.
create table emp
(empno integer
generated always as identity
max value 1000
)
primary index(empno);
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 ? | 2 Yes | 0 No |
which option is used to restart the fast load script?
what is referential constraints?how do you implement RI in teradata?
How you will check the version of teradata?
Difference between multiload and tpump?
Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me
What are the steps involved after the disk manager passes the request?
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
Why does varchar occupy 2 extra bytes?
Diff b/w v2r5 and v2r6 ?
What is a pseudo key? What is its use???
what is use of PI(primary index) AND SI(secondary index)
What are the enhanced features in teradata v2r5 and v2r6?