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?

1096

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 }

How to select first n records in teradata?

1107

What is called partitioned primary index (ppi)?

1013

if collect stats but it show low confidence why?

1688

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

991

How is MLOAD Client System restarted after execution?

1154

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1045

What is meant by a Highest Cost Plan?

1063

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1169

What is meant by a Least Cost Plan?

1060

Explain and compare pros and cons of snow flake schemas?

1035

What are the various etl tools in the market?

1073

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3373

What are different table types used in teradata?

1042

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

1096

What are some commonly used bteq scripts?

1010

For More Un-Answered { Teradata } Questions Click Here