Teradata Interview Questions
Questions Answers Views Company eMail

How to Extract data from multiple legacy systems?

563

What is collect statistics?

580

Differentiate database data and data warehouse data?

577

What does sleep function does in fast load?

609

What is the command in bteq to check for session settings ?

622

Difference between multiload and tpump?

614

What are the scenarios in which full table scans occurs?

525

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

631

How will you solve the problem that occurs during update?

572

What is a dimension table?

602

What are tpump utility limitations?

587

How do you verify a complicated sql?

615

How to eliminate product joins in a teradata sql query?

593

How do you determine the number of sessions?

606

How do you set the session mode parameters in bteq?

597


Post New Teradata Questions

Un-Answered Questions { Teradata }

Name the five phases that come under MultiLoad Utility.

578


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

540


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3899


What are the various etl tools in the market?

574


What is the function of parser component in teradata?

613






What is node? How many nodes and amps used in your previous project?

661


Explain parsing engine in teradata?

579


What are the steps to create a data model?

589


What is meant by a Highest Cost Plan?

614


Explain teradata utilities?

557


What are the different functions performed in development phase?

564


How to eliminate product joins in a teradata sql query?

593


What is meant by a Least Cost Plan?

614


What is the meaning of Caching in Teradata?

684


Steps to create a data model?

650