Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is identity column in TD?

Answer Posted / yuvaevergreen

Identity columns are system generated values. Generally
these columns are used for unique values. Some restrictions are
1. Only 1 column can be specified as identity column.
2. PPIs, Join indexes, hash indexes cannot have identity
columns as indexes.
3."Default" and "Always with cycle" option in identity
columns may result in duplicates.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are differences between teradata and ansi session modes in teradata?

1096


How is MLOAD Teradata Server restarted after execution?

1170


In the Primary Index, what is the score of AMPs that are actively involved?

997


Explain the parallel data extension in teradata?

1027


How would you load a very large file in teradata in general? What utility would you use for it? Why?

1034


Highlight a few of the advantages that ETL tools have over Teradata.

1034


What is meant by a dispatcher?

955


In general, how do you optimze any sql in teradata?

976


Comment whether bottleneck is an error or not.

1073


what are the uses of fact table and dimension table in banking project?

4494


What are the functions involved in shared information architecture?

1017


What are the joins in teradata?

922


There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1062


What is the opening step in basic teradata query script?

981


List out all forms of LOCKS that are available in Teradata.

913