what is identity columns in teradata
Answers were Sorted based on User's Feedback
Answer / yogi
Identity column is used in tables to get the unique
values.Values of the attribute is stored in DBC.idcol. If
ALWAYS and NO CYCLE option is used, then duplicate values
would be avoided.
Is This Answer Correct ? | 3 Yes | 0 No |
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.
Is This Answer Correct ? | 1 Yes | 0 No |
Different phases of multiload?
what are the uses of fact table and dimension table in banking project?
Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update
What is the difference between fastload and multiload? Which one is faster?
Explain the term 'tables' related to relational database management system?
How to identify ppi columns?
What is the difference between SI and JI?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
Name the five phases that come under MultiLoad Utility.
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
Highlight a few of the advantages that ETL tools have over Teradata.
What is spool space? Why do you get spool space errors? How do trouble-shoot them?