Interested to Buy Any Domain ? << Click Here >> for more details...
what is identity columns in TD?
- 2 Answers
- 5535 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 |
What is smp and mpp platforms?
Highlight the advantages of PPI(Partition Primary Index).
Explain and compare pros and cons of snow flake schemas?
What is logical data model?
Why do Hash joins usually perform better than Merge Joins?
What is the difference between global temporary tables and volatile temporary tables?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
How is MLOAD Client System restarted after execution?
What are the different softwares used with their functions in teradata?
What is meant by a node?
How can you track login parameters of users in teradata?
Explain Teradata performance tuning and optimization?
Teradata 
