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

what is the default character set in teradata,,?

2 Answers   IBM, TCS,


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

0 Answers   Infosys, Wells Fargo,


Can you load multiple data files for same target table using fastload?

1 Answers  


1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?

3 Answers  


can i call router is a passive transformation

2 Answers  






Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

0 Answers  


What is the difference between correlated sub queries and inner queries?

4 Answers  


What is meant by a dispatcher?

0 Answers  


What are teradata utilities?

0 Answers  


what is DYNAMIC SQL in TD?

1 Answers   IBM,


Explain the teradata primary index mechanics in detail with a diagram.

0 Answers  


What is the difference between SI and JI?

2 Answers  


Categories