Answer Posted / 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the various indexes in teradata?
Explain Teradata performance tuning and optimization?
How to view every column and the columns contained in indexes in teradata?
What is the use of virtual processor connectivity in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are the components used in smp and massively parallel processing (mpp) machines?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Why do you get spool space errors? How do trouble-shoot them?
What is teradata? Also, list out some of the primary characteristics of teradata.
What do you mean by parsing?
Explain the teradata primary index mechanics in detail with a diagram.
What is the difference between teradata and oracle?
Name the five phases that come under MultiLoad Utility.
Can you connect multiload from ab initio?
What tools would you use for that?