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 |
Where we use PPI in real time??? What is the disadvantages of PPI?
Explain fastload in teradata?
Highlight the limitations of TPUMP Utility.
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
Describe the between keyword in teradata?
How to relege locks in fastload and multiload? example?
How do you design aggregate tables using teradata?
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What are tpump utility limitations?
What do you mean by parsing?
How can you track login parameters of users in teradata?