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 16191

which option is used to restart the fastexport script ?

TCS,

2 10125

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 12893

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

Satyam,

5 32882

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 14263

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 10282

Difference between Teradata V2R5 and Teradata V12 versions?

IBM,

2 8434

How do you eliminate duplicates?

3 8109

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

IBM,

2 8667

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

HP,

1 5647

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 6440

which option is used to restart the fast load script?

2 7155

what are the file sizes in your project?

2 5917

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is bteq script in teradata?

1155

Explain PDE.

1079

Highlight the advantages of PPI(Partition Primary Index).

1075

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1776

What is a node in teradata?

997

What is the maximum number of dml can be coded in a multiload script?

1107

Explain amp in teradata?

1083

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

991

What do you mean by tpt in teradata?

1021

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2477

What are the joins in teradata?

1009

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

985

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

1955

Steps to create a data model?

1132

What are the different table types that are supported by teradata?

1003

For More Un-Answered { Teradata } Questions Click Here