Answers were Sorted based on User's Feedback
Answer / vinay
By Using Identity Column.
/*I am Teradata working professional and Faculty with 7+
yrs of exp posting for knowledge transfer to students.You
can reach me on firstname.lastname@example.org if more
|Is This Answer Correct ?||14 Yes||4 No|
Answer / kk
1-for storing purpose using identity
2-for display purpose using csum
|Is This Answer Correct ?||8 Yes||5 No|
Answer / sridhar
using identity we can generate sequence
generated always/by default as identity (start with <value> increment by <value> min<value> max<value> no cycle)..
|Is This Answer Correct ?||0 Yes||1 No|
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the uses of bynets in multi-node systems?
how do you handle ET and UV errors ?
What tools would you use for that?
What is basic teradata query language?
Difference between stored procedure and macro?
What type of indexing mechanism do we need to use for a typical data warehouse?
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
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.
Is multi insert ansi standard?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.