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 36235

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

5 27097

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 26032

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 212729

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 14901

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

Infosys,

5 15021

why varchar takes 2 extra bytes?

IBM,

4 15389

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

4 12310

Why MLOAD needs Work Tables?

Teradata,

5 24036

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 7258

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 16614

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

3 9993

can i call router is a passive transformation

2 6051

what is the difference between filter and router transmissions

2 6583

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

3369

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1011

What are tpump utility limitations?

1118

Explain parsing engine in teradata?

1083

Write a program to show the parser component used in teradata?

968

What is node? How many nodes and amps used in your previous project?

1106

What do you mean by caching in teradata?

1053

What is stored procedure in teradata?

1020

What is meant by a Least Cost Plan?

1057

What is the use of fallback?

989

List out teradata data types?

1002

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

1094

What are the components provided on node?

1036

What is real time and near real time data warehousing?

1115

List the logical and conditional operators that are used with teradata along with their meanings?

999

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

4551

For More Un-Answered { Teradata } Questions Click Here