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 15998

which option is used to restart the fastexport script ?

TCS,

2 9983

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

2149

what do you mean by INMOD Routines and OUTMODE Routines ?

3 12738

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

Satyam,

5 32636

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 14022

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 10054

Difference between Teradata V2R5 and Teradata V12 versions?

IBM,

2 8305

How do you eliminate duplicates?

3 7951

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

IBM,

2 8526

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

HP,

1 5546

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

Wipro,

2 9082

what is use of fload loading into set table?

IBM,

2 6324

which option is used to restart the fast load script?

2 7024

what are the file sizes in your project?

2 5765

Post New Teradata Questions

Un-Answered Questions { Teradata }

Different phases of multiload?

938

What are the components provided on node?

986

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

928

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2135

What are the different design perspectives used in teradata?

930

What tools would you use for that?

1029

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1662

Can we collect statistics on table level?

990

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

1054

What do you mean by ttu in teradata?

974

What are the steps to create a data model?

984

What are the uses of bynets in multi-node systems?

968

List the logical and conditional operators that are used with teradata along with their meanings?

940

Explain amp in teradata?

1008

What are the different functions performed in development phase?

1015

For More Un-Answered { Teradata } Questions Click Here