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 14729

which option is used to restart the fastexport script ?

TCS,

2 8880

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

1783

what do you mean by INMOD Routines and OUTMODE Routines ?

3 11657

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

Satyam,

5 30796

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 12180

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 8605

Difference between Teradata V2R5 and Teradata V12 versions?

IBM,

2 7494

How do you eliminate duplicates?

3 6938

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

IBM,

2 7537

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

HP,

1 4917

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

Wipro,

2 8147

what is use of fload loading into set table?

IBM,

2 5368

which option is used to restart the fast load script?

2 6266

what are the file sizes in your project?

2 4921


Post New Teradata Questions

Un-Answered Questions { Teradata }

What is the difference between teradata and basic rdbms?

576


Explain the parallel data extension in teradata?

665


What is meant by a node?

628


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

576


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

1783






There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

652


What does Amp contain and what are all the operations that it performs?

596


What are the various reporting tools in the market?

626


if collect stats but it show low confidence why?

1200


What do high confidence, low confidence and no confidence mean in explain plan?

606


What is meant by a Parsing Engine?

717


Why teradata is used?

588


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

1514


What is the function of parser component in teradata?

629


What are the available primary index types?

724