Teradata Interview Questions
Questions Answers Views Company eMail

How many macros we can create inside a macro

Wipro,

1 4737

what is identity columns in teradata

Wipro,

2 6134

what is referential constraints?how do you implement RI in teradata?

Wipro,

2 4493




What is Difference b/w PI & PPI?how to implement PPI?

Wipro,

3 4886

what is identity columns in TD?

Wipro,

2 3345

if a error occured in FASTLOAD is the fastload job stops?

CTS, Deloitte,

1 3274

sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

CTS,

3 6479

what is identity column in TD?

Wipro,

2 5533




How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale

1 7423

Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load

4 4838

How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?

IBM,

2 10945

what happen if a query fail in dispatcher?

Cap Gemini,

1 5436

what is the structure of UV table in MLOAD?

Cap Gemini,

4 11906

what is DYNAMIC SQL in TD?

IBM,

1 4659

what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?

HCL,

3 6987


Post New Teradata Questions






Un-Answered Questions { Teradata }

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

605


If RDBMS is halted what will you do ?

1062


what are the day to day activities of teradata DBA ?

4446


any one answer me how they can analyzing the project using data ware housing?

1418


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

2201






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

2472


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

899


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?

972


what is sysdba and sysdbc ? which has high priority ?

2666


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

976


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1045


how can we analyze the locks ?

1011


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

827


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1108


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

2959