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 36288

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

5 27136

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 26175

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 213925

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 14920

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

Infosys,

5 15069

why varchar takes 2 extra bytes?

IBM,

4 15436

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

4 12333

Why MLOAD needs Work Tables?

Teradata,

5 24090

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 7283

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 16656

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

3 10025

can i call router is a passive transformation

2 6082

what is the difference between filter and router transmissions

2 6609

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

3375

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is bteq utility in teradata?

984

What are the steps involved after the disk manager passes the request?

1123

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

1065

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1169

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1171

what is sysdba and sysdbc ? which has high priority ?

3834

What are the components provided on node?

1048

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

990

What are the different design perspectives used in teradata?

983

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

992

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1049

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

1109

Why are oltp database designs not generally a good idea for a data warehouse?

1059

How is the teradata different from oracle?

1119

What are default access rights in teradata? What explicit right can be given to a user?

1112

For More Un-Answered { Teradata } Questions Click Here