Interested to Buy Any Domain ? << Click Here >> for more details...
what is identity columns in teradata
- 2 Answers
- 9418 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Explain BYNET.
Why do you get spool space errors? How do trouble-shoot them?
How to cast date "2015-03-03-012204-000000" to timestamp
What is partitioned primary index (ppi)?
How to view every column and the columns contained in indexes in teradata?
What is TPD?
What are the different functions included in the server software?
How to Extract data from multiple legacy systems?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
Explain the term 'tables' related to relational database management system?
What are the things to be considered while creating secondary index?
Explain the new features of teradata?
Teradata 
