Answer Posted / 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);

How to load specific no.of records using bteq, or fastload,or multiload

1816

---

what are the uses of fact table and dimension table in banking project?

4601

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1212

---

How would you load a very large file in teradata in general?

1090

---

What are the various indexes in teradata?

1096

---

What are the different softwares used with their functions in teradata?

1061

---

What is stored procedure in teradata?

1087

---

What is the use of having index on table?

1041

---

What is the purpose of joins in teradata?

1262

---

What is the use of teradata system software?

1089

---

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

1039

---

What is difference between user and database in teradata?

1117

---

What is the difference between global temporary tables and volatile temporary tables?

1240

---

Explain and compare pros and cons of start schemas?

1150

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2242

---