Interested to Buy Any Domain ? << Click Here >> for more details...
what is identity columns in TD?
- 2 Answers
- 5796 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 |
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
Describe the set operators in teradata.
which utitility can use for loading the data from non-teradata to teradata ?
What is bteq utility in teradata?
What is basic teradata query language?
Highlight the limitations of TPUMP Utility.
Highlight a few of the important components of Teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
What are teradata utilities?
How do you create a table with an existing structure of another table with data and with no data?
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 ?
What are default access rights in teradata? What explicit right can be given to a user?
Teradata 
