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

Highlight the points of differences between the database and user in Teradata.

591


What are the primary characteristics of the Teradata.

593


What is meant by a Highest Cost Plan?

624


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1282


What is the difference between fastload and multiload? Which one is faster?

601






What are the functions of a Parser?

610


What are the various etl tools in the market?

587


Describe the between keyword in teradata?

612


In Teradata, what is the significance of UPSERT command?

597


How do you see a ddl for an existing table?

575


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3913


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

377


What is stored procedure in teradata?

590


What are the different functions performed in development phase?

573


What is inner join and outer join?

618