Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Teradata Interview Questions
Questions Answers Views Company eMail

How many macros we can create inside a macro

Wipro,

1 5055

what is identity columns in teradata

Wipro,

2 6848

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

Wipro,

2 4862

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

Wipro,

3 5403

what is identity columns in TD?

Wipro,

2 3698

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

CTS, Deloitte,

1 3744

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 7244

what is identity column in TD?

Wipro,

2 5850

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 7881

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 5330

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

IBM,

2 11676

what happen if a query fail in dispatcher?

Cap Gemini,

1 5889

what is the structure of UV table in MLOAD?

Cap Gemini,

4 13082

what is DYNAMIC SQL in TD?

IBM,

1 4950

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 7766


Post New Teradata Questions






Un-Answered Questions { Teradata }

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

177


What is the multi-insert?

161


In Teradata, how do we Generate Sequence?

165


What are the available primary index types in teradata.

145


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

136






What is real time and near real time data warehousing?

172


Did you write stored procedures in teradata?

161


What do you mean by parsing?

162


What is spool space? Why do you get spool space errors?

118


What is bteq utility in teradata?

135


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

169


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

787


What are normalization, first normal form, second normal form and third normal form?

173


Mention a few of the ETL tools that come under Teradata.

176


What is the opening step in basic teradata query script?

154