Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

Difference between star and snowflake schemas?

1048

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?

1059

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

1082

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

926

How do you see a ddl for an existing table?

962

How many codd's rules are satisfied by teradata database?

1045

What is difference between user and database in teradata?

1025

What is the difference between fastload and multiload?

1289

What is real time and near real time data warehousing?

1063

What is dimensional modeling?

1013

What are the multiload utility limitations?

1003

What is a sparse index?

1022

Can we collect statistics on table level?

987

What interface is used to connect to windows based applications?

1037

What is primary index and secondary index?

973

Post New Teradata Questions

Un-Answered Questions { Teradata }

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3315

Which is more efficient group by or distinct to find duplicates?

1034

What are types of partition primary index (ppi) in teradata?

999

How do you see a ddl for an existing table?

962

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

1086

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1105

What is the use of teradata system software?

984

What is meant by a Highest Cost Plan?

988

What is the basic syntax for teradata select statement?

983

Describe primary index in teradata. And what are the available primary index types?

937

Steps to create a data model?

1061

What are the string manipulation operators and functions associated with teradata?

1025

Explain fastload in teradata?

1038

What is primary index and secondary index?

973

Explain the term 'row' related to relational database management system?

886

For More Un-Answered { Teradata } Questions Click Here