Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

Is multi insert ansi standard?

2206

How does hashing happens in teradata?

1091

What's the syntax of sub string?

1 2586

How many types of index are present in teradata?

1 1811

How to select first n records in teradata?

1107

What is a level of granularity of a fact table?

1158

What is logical data model?

1204

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

1052

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

1095

What is the purpose of indexes?

1074

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

1166

Can we collect statistics on multiple columns?

1067

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

1 1579

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

1 1675

Can you connect multiload from ab initio?

1215

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is partitioned primary index (ppi)?

1048

What is meant by a Highest Cost Plan?

1063

Difference between star and snowflake schemas?

1152

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

1223

What is upsert statement in teradata?

1137

What are the different methods ot loading a dimension table? A fact table etc?

1036

Can we collect statistics on multiple columns?

1067

How many codd's rules are satisfied by teradata database?

1112

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1955

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

1100

What do you mean by tpt in teradata?

1021

What are the uses of client software involved in teradata?

984

How to eliminate product joins in a teradata sql query?

1029

What are the various reporting tools in the market?

1070

How do you define Teradata?

1035

For More Un-Answered { Teradata } Questions Click Here