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.

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

9 Answers   IBM,

---

How is Teradata in current market?

4 Answers  

---

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers   IBM,

---

How to run a query in teradata?

0 Answers  

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

0 Answers  

---

How many macros we can create inside a macro

1 Answers   Wipro,

---

Explain the most common data types used in teradata?

0 Answers  

---

If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?

1 Answers   Teradata,

---

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 Answers  

---

How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale

1 Answers  

---

Explain fastload in teradata?

0 Answers  

---

Difference between stored procedure and macro?

0 Answers  

---