what is identity columns in TD?

Answers were Sorted based on User's Feedback



what is identity columns in TD?..

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

what is identity columns in TD?..

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

Post New Answer

More Teradata Interview Questions

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

0 Answers   IBM,


What is bteq utility in teradata?

0 Answers  


Explain and compare pros and cons of snow flake schemas?

0 Answers  


Describe primary index in teradata. And what are the available primary index types?

0 Answers  


The transaction exceeded the maximum number of rowhash locks allowed

1 Answers   Wipro,






which utitility can use for loading the data from non-teradata to teradata ?

5 Answers   Wipro,


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

0 Answers  


Differentiate database data and data warehouse data?

0 Answers  


what is single value and Multivalue ?

1 Answers   IBM, Wipro,


Explain the parallel data extension in teradata?

0 Answers  


how can we analyze the locks ?

0 Answers   HP,


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?

4 Answers   IBM,


Categories