what is identity columns in teradata
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 |
How to run the Teradata jobs in unix environment ???
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
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 is meant by a dispatcher?
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?
Comment whether bottleneck is an error or not.
How is MLOAD Client System restarted after execution?
what is object level locking ? where do appear this type of locking ?
List out some of the primary characteristics of teradata.
What is the difference between fastload and multiload? Which one is faster?
Explain teradata utilities?
What is a dimension table?