Interested to Buy Any Domain ? << Click Here >> for more details...
what is identity columns in teradata
- 2 Answers
- 9363 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
What are the uses of client software involved in teradata?
if collect stats but it show low confidence why?
What is meant by a node?
What are the different functions included in the server software?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What are aggregate tables? How do you design them using teradata?
What is inner join and outer join?
What are the functions involved in shared information architecture?
What do you mean by parsing?
What is partitioned primary index (ppi)?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Teradata 
