Teradata Interview Questions
Questions Answers Views Company eMail

Is multi insert ansi standard?

1746

How does hashing happens in teradata?

620

What's the syntax of sub string?

1 1849

How many types of index are present in teradata?

1 934

How to select first n records in teradata?

609

What is a level of granularity of a fact table?

637

What is logical data model?

640

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

624

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

677

What is the purpose of indexes?

588

What type of indexing mechanism do we need to use for a typical data warehouse?

615

Can we collect statistics on multiple columns?

564

How do you create a table with an existing structure of another table with data and with no data?

1 869

Can you load multiple data files for same target table using fastload?

1 877

Can you connect multiload from ab initio?

640


Post New Teradata Questions

Un-Answered Questions { Teradata }

In Teradata, how do we Generate Sequence?

602


Explain the advantages of partitioned primary index in a query?

564


How do you verify a complicated sql?

628


Where is teradata rdbms used?

672


List out some of the primary characteristics of teradata.

554






In BTEQ, how are the session-mode parameters being set?

656


Explain amp in teradata?

571


How do you set the session mode parameters in bteq?

608


What is meant by a node?

618


What are default access rights in teradata?

623


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

586


What are the functions involved in shared information architecture?

601


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

547


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

690


What is meant by a Least Cost Plan?

621