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

Teradata Interview Questions

Questions Answers Views Company eMail

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 16351

which option is used to restart the fastexport script ?

TCS,

2 10226

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2261

what do you mean by INMOD Routines and OUTMODE Routines ?

3 13025

1.what is activity count? 2.what is skew factor? how it's working explain brefily

Satyam,

5 33082

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

Cap Gemini,

6 14473

whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?

HCL,

5 10447

Difference between Teradata V2R5 and Teradata V12 versions?

IBM,

2 8538

How do you eliminate duplicates?

3 8233

what is the difference between primary index and secondary index?.

IBM,

2 8791

can we load 10 millions of records into target table by using tpump?

HP,

1 5724

where we can use the delimiter in mload? pls let me know

Wipro,

2 9297

what is use of fload loading into set table?

IBM,

2 6537

which option is used to restart the fast load script?

2 7242

what are the file sizes in your project?

2 5994

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is the basic syntax for teradata select statement?

1094

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2190

What are the components provided on node?

1090

Explain teradata architecture in detail with a diagram.

1165

What is the opening step in basic teradata query script?

1091

What is teradata and why it is used?

1180

What exactly do you know about catching in teradata?

1078

What is the use of virtual processor connectivity in teradata?

1085

How do you verify a complicated sql?

1114

Discuss the advantages of using partitioned primary index in a query?

999

What are the various indexes in teradata? How to use them?

1072

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4421

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

2000

What is the function of parser component in teradata?

1130

What is the purpose of indexes?

1128

For More Un-Answered { Teradata } Questions Click Here