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 14664

which option is used to restart the fastexport script ?

TCS,

2 8800

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

1755

what do you mean by INMOD Routines and OUTMODE Routines ?

3 11599

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

Satyam,

5 30669

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 12060

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 8508

Difference between Teradata V2R5 and Teradata V12 versions?

IBM,

2 7444

How do you eliminate duplicates?

3 6866

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

IBM,

2 7480

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

HP,

1 4882

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

Wipro,

2 8078

what is use of fload loading into set table?

IBM,

2 5299

which option is used to restart the fast load script?

2 6240

what are the file sizes in your project?

2 4874


Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the things to be considered while creating secondary index?

618


What is the opening step in basic teradata query script?

584


What is database exceptions in teradata?

531


What are aggregate tables? How do you design them using teradata?

624


Explain amp in teradata?

562






What is called partitioned primary index (ppi)?

548


Give a justifiable reason why Multi-load supports NUSI instead of USI.

662


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

1724


What can be achieved by using the teradata rdbms?

614


Explain how spool space is used.

603


Explain Teradata performance tuning and optimization?

682


Define views in teradata with general syntax.

560


If RDBMS is halted what will you do ?

1695


how many modules are there in telecome domain?how to explain the architecture?

1541


Highlight the need for Performance Tuning.

569