Teradata Interview Questions
Questions Answers Views Company eMail

What is the use of having index's on table?

1 1827

Difference between inner join and outer join?

574

What are the functions of a teradata dba?

588

What are the various reporting tools in the market?

603

How to identify ppi columns?

641

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

647

How can you track login parameters of users in teradata?

622

When tpump is used instead of multiload?

617

What are the various etl tools in the market?

574

How to find duplicates in a table?

602

What is basic teradata query language?

624

Steps to create a data model?

650

Can you fastexport a field, which is primary key by putting equality on that key?

701

While creating table my dba has fallback or no fallback in his ddl. What is that?

677

Syntax for case when statement?

600


Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the available primary index types?

705


What is the difference between fastload and multiload? Which one is faster?

585


What happens in a conflict? How do you handle that?

611


What is the opening step in basic teradata query script?

587


What are the steps involved in the process flow of the sql statement through channel attached system?

653






What are the 5 phases in a multiload utility?

600


What is meant by Teradata Gateway?

572


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?

625


What are the available join types in teradata?

586


Why are oltp database designs not generally a good idea for a data warehouse?

591


Explain the term 'database' related to relational database management system?

563


What do high confidence, low confidence and no confidence mean in explain plan?

579


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

2990


What happens when a node suffers a downfall?

660


In general, how do you optimze any sql in teradata?

535