Discuss the advantages of using partitioned primary index in a query?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Teradata Interview Questions

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

0 Answers  


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

5 Answers   CTS, TCS,


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

0 Answers  


What's the syntax of sub string?

1 Answers  


If a Node is busy what are the steps you can take to avoid ?

0 Answers   Teradata,


Why AMP & PE are called Vprocs?

4 Answers  


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

0 Answers  


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

0 Answers  


whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?

5 Answers   HCL,


Explain amp in teradata?

0 Answers  


Can you connect multiload from ab initio?

0 Answers  


What are the different methods ot loading a dimension table? A fact table etc?

0 Answers  


Categories