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

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.

which option is used to restart the fast load script?

2 Answers  

---

what is referential constraints?how do you implement RI in teradata?

2 Answers   Wipro,

---

How you will check the version of teradata?

0 Answers  

---

Difference between multiload and tpump?

0 Answers  

---

Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me

25 Answers   TCS,

---

---

What are the steps involved after the disk manager passes the request?

0 Answers  

---

i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.

1 Answers  

---

Why does varchar occupy 2 extra bytes?

0 Answers  

---

Diff b/w v2r5 and v2r6 ?

3 Answers   TCS,

---

What is a pseudo key? What is its use???

2 Answers   Mphasis,

---

what is use of PI(primary index) AND SI(secondary index)

2 Answers   Wipro,

---

What are the enhanced features in teradata v2r5 and v2r6?

0 Answers  

---