Answer Posted / surendra reddy duggireddy

Identity Columns generate a system-generated number for
every row as it is inserted
in the table. It is also knows as a DBS Generated Unique
Primary Index. Identity
Columns are used if you want to guarantee row uniqueness in
a table and they can
simplify the initial port from databases other than
Teradata. They are often used as the
Primary Index so they can guarantee even distribution. In
some cases they are utilized to
optimize and simplify the first port from another database
that uses generated keys.
Identity columns do NOT need to be part of the Primary
Index, but they are often used
for that purpose because they provide even data
distribution. The biggest rule is that
you can only specify one Identity Column per table



Example:
-------
Create Table Employee_Table
( Employee_No INTEGER
GENERATED ALWAYS AS IDENTITY
(START WITH 1 INCREMENT BY 5
MAXVALUE 1000000
NO CYCLE)
, Dept_No INTEGER
,First_Name CHAR(20)
,Last_Name CHAR(20)
,Salary DECIMAL (10,2)
) PRIMARY INDEX (Employee_No);

What are the string manipulation operators and functions associated with teradata?

1025

---

How to run a query in teradata?

1007

---

Explain the term 'row' related to relational database management system?

887

---

Highlight the limitations of TPUMP Utility.

1048

---

What is the primary index in teradata?

1113

---

Syntax for case when statement?

1007

---

What are the different methods ot loading a dimension table? A fact table etc?

977

---

What are the components used in smp and massively parallel processing (mpp) machines?

1001

---

What are the different table types supported by teradata?

893

---

What do you mean by fastexport in teradata?

940

---

What is smp and mpp platforms?

900

---

How is MLOAD Client System restarted after execution?

1057

---

Describe the set operators in teradata.

952

---

What are the various indexes in teradata? How to use them?

954

---

What are the things to be considered while creating secondary index?

1034

---