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 16015

which option is used to restart the fastexport script ?

TCS,

2 10001

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

2162

what do you mean by INMOD Routines and OUTMODE Routines ?

3 12765

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

Satyam,

5 32675

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 14066

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 10077

Difference between Teradata V2R5 and Teradata V12 versions?

IBM,

2 8317

How do you eliminate duplicates?

3 7972

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

IBM,

2 8545

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

HP,

1 5562

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

Wipro,

2 9098

what is use of fload loading into set table?

IBM,

2 6334

which option is used to restart the fast load script?

2 7048

what are the file sizes in your project?

2 5788

Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the scenarios in which full table scans occurs?

955

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

1887

What is multi insert?

996

What can be achieved by using the teradata rdbms?

991

What is meant by a Parsing Engine?

1141

Highlight a few of the advantages that ETL tools have over Teradata.

1040

how can we analyze the locks ?

2069

Explain the term 'columns' related to relational database management system?

1005

Describe the between keyword in teradata?

991

What do you mean by teradata intelliflex?

1049

What are the functions involved in shared information architecture?

1031

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1032

How can we check the version of Teradata that we are using currently?

1021

How to Extract data from multiple legacy systems?

1051

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

970

For More Un-Answered { Teradata } Questions Click Here