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 16193

which option is used to restart the fastexport script ?

TCS,

2 10126

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

2202

what do you mean by INMOD Routines and OUTMODE Routines ?

3 12896

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

Satyam,

5 32884

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 14264

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 10284

Difference between Teradata V2R5 and Teradata V12 versions?

IBM,

2 8435

How do you eliminate duplicates?

3 8112

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

IBM,

2 8669

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

HP,

1 5650

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

Wipro,

2 9209

what is use of fload loading into set table?

IBM,

2 6442

which option is used to restart the fast load script?

2 7156

what are the file sizes in your project?

2 5918

Post New Teradata Questions

Un-Answered Questions { Teradata }

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1203

List out teradata data types?

1007

Explain vproc in teradata?

1001

What is the use of teradata system software?

1039

Is multi insert ansi standard?

2206

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

1052

Explain the advantages of partitioned primary index in a query?

1027

What is the syntax for case when statement?

1143

How to load specific no.of records using bteq, or fastload,or multiload

1747

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

2048

What is bteq utility in teradata?

974

What do you mean by tpt in teradata?

1021

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1153

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

2202

What are the different softwares used with their functions in teradata?

1015

For More Un-Answered { Teradata } Questions Click Here