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);

What do you mean by fastexport in teradata?

996

---

What does sleep function does in fast load?

1133

---

What is the purpose of indexes?

1069

---

In the Primary Index, what is the score of AMPs that are actively involved?

1073

---

Why are oltp database designs not generally a good idea for a data warehouse?

1054

---

any one answer me how they can analyzing the project using data ware housing?

2469

---

What do high confidence, low confidence and no confidence mean in explain plan?

1043

---

What is partitioned primary index (ppi)?

1047

---

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

980

---

What is a sparse index?

1074

---

Explain the meaning of Amp?

1144

---

what is object level locking ? where do appear this type of locking ?

3490

---

Explain teradata vs. Redshift?

1012

---

If a Node is busy what are the steps you can take to avoid ?

2410

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1073

---