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 16181

which option is used to restart the fastexport script ?

TCS,

2 10113

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

2200

what do you mean by INMOD Routines and OUTMODE Routines ?

3 12878

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

Satyam,

5 32857

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 14252

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 10254

Difference between Teradata V2R5 and Teradata V12 versions?

IBM,

2 8417

How do you eliminate duplicates?

3 8089

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

IBM,

2 8655

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

HP,

1 5636

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

Wipro,

2 9200

what is use of fload loading into set table?

IBM,

2 6426

which option is used to restart the fast load script?

2 7148

what are the file sizes in your project?

2 5908

Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the main components of teradata system?

1123

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

1006

Explain the meaning of Amp?

1140

how do you manage the production space. what are the proactive methods you can take ?

1939

What are default access rights in teradata?

1110

Highlight the advantages of PPI(Partition Primary Index).

1072

What is teradata and why it is used?

1088

What are the joins in teradata?

982

Why is the case expression used in teradata?

1071

What is oltp?

971

What do you mean by caching in teradata?

1054

Define views in teradata with general syntax.

1021

What is partitioned primary index (ppi)?

1044

What is teradata? What are some primary characteristics of teradata?

967

How to find duplicates in a table?

1204

For More Un-Answered { Teradata } Questions Click Here