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 |
what is the default character set in teradata,,?
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. 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?
can i call router is a passive transformation
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is the difference between correlated sub queries and inner queries?
What is meant by a dispatcher?
What are teradata utilities?
what is DYNAMIC SQL in TD?
Explain the teradata primary index mechanics in detail with a diagram.
What is the difference between SI and JI?