Interested to Buy Any Domain ? << Click Here >> for more details...
what is identity columns in TD?
- 2 Answers
- 5700 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Explain and compare pros and cons of start schemas?
What are the things to be considered while creating secondary index?
how to load or extract the error table data ?
What are the joins in teradata and how many types of joins are there in teradata?
Highlight the differences between Primary Key and Primary Index.
How many types of joins are there in teradata?
What exactly do you know about catching in teradata?
Why MLOAD needs Work Tables?
Explain the teradata primary index mechanics in detail with a diagram.
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is meant by Teradata Gateway?
Which Teradata concept allows more than one model generation?
Teradata 
