Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

What is Join Index in TD and How it works?

BT, CSC, TCS,

6 36267

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 27127

Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me

TCS,

25 26125

I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com

Cognizant, Deloitte, IBM, Prometric, Syntel,

201 213589

Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?

2 14915

Increasing no of amps will increase performance. Is this true?

Infosys,

5 15048

why varchar takes 2 extra bytes?

IBM,

4 15419

How to copy 1 million records from one DB to another, Which is effective interms of performance?

4 12320

Why MLOAD needs Work Tables?

Teradata,

5 24059

1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?

3 7277

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

Accenture, Cognizant,

5 16645

How can we load single row of data into teradata database. please give me the process.

3 10016

can i call router is a passive transformation

2 6070

what is the difference between filter and router transmissions

2 6600

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3373

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

1012

what are the uses of fact table and dimension table in banking project?

4556

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

991

What are the functions of a Parser?

1113

What is meant by a Highest Cost Plan?

1063

What is meant by a Virtual Disk?

1136

What is a sparse index?

1082

In general, how do you optimze any sql in teradata?

1041

What are the string manipulation operators and functions associated with teradata?

1090

What are the different functions included in the server software?

1031

If a Node is busy what are the steps you can take to avoid ?

2414

What are the various indexes in teradata? Why are they preferred?

1005

What is a level of granularity of a fact table?

1158

What is collect statistics?

998

Why managing the data is important?

1015

For More Un-Answered { Teradata } Questions Click Here