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 36271

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

5 27129

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 26132

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 213646

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 14916

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

Infosys,

5 15052

why varchar takes 2 extra bytes?

IBM,

4 15423

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

4 12321

Why MLOAD needs Work Tables?

Teradata,

5 24061

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 7279

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 16646

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

3 10017

can i call router is a passive transformation

2 6073

what is the difference between filter and router transmissions

2 6601

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 different functions performed in development phase?

1080

What is oltp?

977

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2121

What is the difference between teradata and oracle?

1027

Highlight the need for Performance Tuning.

1105

What are the steps to create a data model?

1053

What is the function of parser component in teradata?

1085

Different phases of multiload?

1011

Explain the term 'tables' related to relational database management system?

1048

What is the difference between global temporary tables and volatile temporary tables?

1182

What is the command in bteq to check for session settings ?

1180

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

1042

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1169

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

986

Explain teradata architecture in detail with a diagram.

1113

For More Un-Answered { Teradata } Questions Click Here