Discuss the advantages of using partitioned primary index in a query?
Highlight a few of the advantages that ETL tools have over Teradata.
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
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What's the syntax of sub string?
If a Node is busy what are the steps you can take to avoid ?
Why AMP & PE are called Vprocs?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
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?
Explain amp in teradata?
Can you connect multiload from ab initio?
What are the different methods ot loading a dimension table? A fact table etc?