Interested to Buy Any Domain ? << Click Here >> for more details...
what is identity columns in TD?
- 2 Answers
- 5638 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 |
How can bottlenecks be identified?
How do you eliminate duplicates?
How do you see a ddl for an existing table?
Is multi insert ansi standard?
What is the purpose of joins in teradata and what are the available join types?
Diff b/w v2r5 and v2r6 ?
What are the scenarios in which full table scans occurs?
What is Join Index in TD and How it works?
what is the difference between filter and router transmissions
Discuss the advantages of using partitioned primary index in a query?
1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?
6 Answers Bank Of America, Wipro,
How do you design aggregate tables using teradata?
Teradata 
