Interested to Buy Any Domain ? << Click Here >> for more details...
what is identity columns in teradata
- 2 Answers
- 9522 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 |
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
what is the difference between start schma and Fsldm?
Describe the between keyword in teradata?
What are the functions involved in shared information architecture?
What tools would you use for that?
Did you write stored procedures in teradata?
Syntax for case when statement?
what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
can i call router is a passive transformation
What is Join Index in TD and How it works?
Explain vproc in teradata?
Highlight a few of the important components of Teradata?
Teradata 
