What is the use of having index on table?

743

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

765

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?

851

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

856

Why does varchar occupy 2 extra bytes?

835

What is the multi-insert?

798

What is bteq utility in teradata?

734

What interface is used to connect to windows based applications?

802

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

751

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3276

how do you manage the production space. what are the proactive methods you can take ?

1666

Describe the between keyword in teradata?

815

What is bteq script in teradata?

822

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

947

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

848