Answer Posted / sridhar
using identity we can generate sequence
syntax:
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 |
Post New Answer View All Answers
Explain the meaning of Amp?
How is MLOAD Client System restarted after execution?
In general, how do you optimze any sql in teradata?
What happens in a conflict? How do you handle that?
What is the purpose of joins in teradata and what are the available join types?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Highlight the advantages of PPI(Partition Primary Index).
What is spool space?
What is the maximum number of dml can be coded in a multiload script?
What are the steps to create a data model?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What do you mean by caching in teradata?
How many tables can you join in v2r5?
Name the five phases that come under MultiLoad Utility.
What are the joins in teradata and how many types of joins are there in teradata?