Teradata Interview Questions
Questions Answers Views Company eMail

How to Extract data from multiple legacy systems?

576

What is collect statistics?

589

Differentiate database data and data warehouse data?

588

What does sleep function does in fast load?

620

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

636

Difference between multiload and tpump?

623

What are the scenarios in which full table scans occurs?

538

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

646

How will you solve the problem that occurs during update?

587

What is a dimension table?

610

What are tpump utility limitations?

597

How do you verify a complicated sql?

631

How to eliminate product joins in a teradata sql query?

605

How do you determine the number of sessions?

615

How do you set the session mode parameters in bteq?

611


Post New Teradata Questions

Un-Answered Questions { Teradata }

What is teradata and why it is used?

587


A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

689


What's the difference between timestamp (0) and timestamp (6)?

640


Steps to create a data model?

662


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1281






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

637


What is a node in teradata? Explain

603


How would you load a very large file in teradata in general? What utility would you use for it? Why?

601


Explain the new features of teradata?

571


What are normalization, first normal form, second normal form and third normal form?

629


What are the different functions performed in development phase?

573


What are the functions of a Parser?

610


How do you see a ddl for an existing table?

575


Where is teradata rdbms used?

675


What is meant by a dispatcher?

570