what is identity columns in TD?
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 |
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What is bteq utility in teradata?
Explain and compare pros and cons of snow flake schemas?
Describe primary index in teradata. And what are the available primary index types?
The transaction exceeded the maximum number of rowhash locks allowed
which utitility can use for loading the data from non-teradata to teradata ?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Differentiate database data and data warehouse data?
what is single value and Multivalue ?
Explain the parallel data extension in teradata?
how can we analyze the locks ?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?