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

Teradata Interview Questions

Questions Answers Views Company eMail

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?

IBM,

2040

On which column will you take primary index???

4 8797

What are the differences between TerdataV2R5 and V12 Versions please??

3 7048

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 4085

what are the default access rights in the teradata?

1 7168

Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q

45 49696

How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.

2 6582

wt r before journal& after journel.....in teradata

4 9447

in teradata level primary in table level allows duplicates why?

TCS,

1 6149

in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

IBM,

1 5515

Which Teradata concept allows more than one model generation?

TCS,

1 10761

what is object level locking ? where do appear this type of locking ?

3448

how can i answer for question like teradat architecture in interveiw

TCS,

4 10334

plz explain parlla distribution and subtable concept in teradata

TCS,

3 9473

how many modules are there in telecome domain?how to explain the architecture?

1964

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is the meaning of Caching in Teradata?

1082

Explain Teradata performance tuning and optimization?

1108

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1059

What are the scenarios in which full table scans occurs?

941

What do you mean by ttu in teradata?

974

How to run a query in teradata?

1010

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2094

Explain the meaning of Amp?

1035

Highlight all the modes that are present under Confidence Level.

918

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

1084

What are differences between teradata and ansi session modes in teradata?

1096

What is inner join and outer join?

1037

What is the use of teradata system software?

986

What exactly do you know about catching in teradata?

991

What is meant by Teradata Gateway?

1006

For More Un-Answered { Teradata } Questions Click Here