Teradata Interview Questions
Questions Answers Views Company eMail

Highlight the limitations of TPUMP Utility.

578

Explain PDE.

582

What is meant by a Highest Cost Plan?

597

During the Display time, how is the sequence generated by Teradata?

595

How is MLOAD Client System restarted after execution?

575

What is meant by a node?

593

What are differences between teradata and ansi session modes in teradata?

594

Differentiate primary key and partition key?

555

What is a clique?

562

What are the 5 phases in a multiload utility?

590

Which is faster fastload or multiload?

573

What is the opening step in basic teradata query script?

569

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

566

What is oltp?

546

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

647


Post New Teradata Questions

Un-Answered Questions { Teradata }

What is collect statistics?

560


What do you mean by caching in teradata?

584


Explain parsing engine in teradata?

564


What is the purpose of indexes?

567


What is meant by a Highest Cost Plan?

597






Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

602


Explain teradata utilities. What is multiload, fast load, tpump?

544


What is real time and near real time data warehousing?

646


What is oltp?

546


What is the meaning of Caching in Teradata?

666


What is the opening step in basic teradata query script?

569


Explain and compare pros and cons of start schemas?

521


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

654


Highlight the advantages of PPI(Partition Primary Index).

539


What are some primary characteristics of teradata?

522