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...

Is PK concept available in Teradata. If it is how can we
create Primary Key for a table in TD

Answer Posted / tdguy

PK is a logical concept and not mandatory in TD. But PI is
mandatory as the distribution of data is completely
dependent on PI. Choice of PI is very important and can
contain upto 16 columns.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between union and union all in teradata?

1080


Difference between multiload and tpump?

1060


How many types of joins are there in teradata?

932


If RDBMS is halted what will you do ?

2123


What is teradata? What are some primary characteristics of teradata?

945


Where is teradata rdbms used?

1056


What are the different table types that are supported by teradata?

973


In BTEQ, how are the session-mode parameters being set?

1105


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1039


What is meant by a node?

1002


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2157


What is the difference between global temporary tables and volatile temporary tables?

1099


Explain amp in teradata?

1029


what is object level locking ? where do appear this type of locking ?

3456


What are the commands to make a new table, change a table and remove a table in teradata?

1091