Teradata Interview Questions
Questions Answers Views Company eMail

Difference between star and snowflake schemas?

578

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?

612

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

610

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

539

How do you see a ddl for an existing table?

551

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

638

What is difference between user and database in teradata?

589

What is the difference between fastload and multiload?

750

What is real time and near real time data warehousing?

646

What is dimensional modeling?

567

What are the multiload utility limitations?

567

What is a sparse index?

601

Can we collect statistics on table level?

577

What interface is used to connect to windows based applications?

557

What is primary index and secondary index?

544


Post New Teradata Questions

Un-Answered Questions { Teradata }

Highlight all the modes that are present under Confidence Level.

522


What are the different functions included in the server software?

578


What is primary index and secondary index?

544


Give the sizes of SMALLINT, BYTEINT and INTEGER.

641


What is the use of virtual processor connectivity in teradata?

539






What is meant by a Clique?

560


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

520


What is spool space? Why do you get spool space errors?

486


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

630


What are some commonly used bteq scripts?

546


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

605


What do you mean by fastexport in teradata?

525


What are the various indexes in teradata? Why are they preferred?

533


What is the difference between fastload and multiload?

750


What tools would you use for that?

543