Interested to Buy Any Domain ? << Click Here >> for more details...
what is identity columns in teradata
- 2 Answers
- 9261 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 |
What is the meaning of Caching in Teradata?
How do you Generate Sequence in Teradata?
What are the newly developed features of Teradata?
which option is used to restart the fast load script?
What is real time and near real time data warehousing?
What is meant by a node?
Highlight a few of the advantages that ETL tools have over Teradata.
What is the purpose of joins in teradata and what are the available join types?
What is a clique?
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
What is the use of teradata system software?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Teradata 
