Teradata Interview Questions
Questions Answers Views Company eMail

What is the meaning of Caching in Teradata?

667

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

617

What is meant by a Channel Driver?

622

How many sessions of MAX is PE capable of handling at a particular time?

567

What happens when a node suffers a downfall?

647

What are the functions of a Parser?

584

What is meant by Teradata Gateway?

559

Highlight the differences between Primary Key and Primary Index.

590

What is meant by a Clique?

561

Explain the meaning of Amp?

561

In Teradata, what is the significance of UPSERT command?

566

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

575

List out all forms of LOCKS that are available in Teradata.

524

What does Amp contain and what are all the operations that it performs?

563

Mention a few of the ETL tools that come under Teradata.

593


Post New Teradata Questions

Un-Answered Questions { Teradata }

Differentiate primary key and partition key?

556


What is the difference between teradata and basic rdbms?

540


What is a dimension table?

585


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

586


What are the various indexes in teradata?

542






How does hashing happens in teradata?

594


if collect stats but it show low confidence why?

1163


How do you do backup and recovery in teradata?

522


Syntax for case when statement?

584


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

558


Explain Teradata performance tuning and optimization?

665


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

520


Explain fallback in teradata?

584


What is stored procedure in teradata?

564


What is meant by a Parsing Engine?

679