Teradata Interview Questions
Questions Answers Views Company eMail

How many macros we can create inside a macro

Wipro,

1 4617

what is identity columns in teradata

Wipro,

2 5818

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

Wipro,

2 4370




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

Wipro,

3 4708

what is identity columns in TD?

Wipro,

2 3209

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

CTS, Deloitte,

1 3110

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 6234

what is identity column in TD?

Wipro,

2 5431




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 7266

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 4697

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

IBM,

2 10700

what happen if a query fail in dispatcher?

Cap Gemini,

1 5204

what is the structure of UV table in MLOAD?

Cap Gemini,

4 11420

what is DYNAMIC SQL in TD?

IBM,

1 4553

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 6717


Post New Teradata Questions






Un-Answered Questions { Teradata }

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

2417


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

1373


what is sysdba and sysdbc ? which has high priority ?

2614


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

779


If a Node is busy what are the steps you can take to avoid ?

1217






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

2805


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

1650


if collect stats but it show low confidence why?

73


how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

569


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

2114


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

561


How to load specific no.of records using bteq, or fastload,or multiload

531


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

3383


how do you manage the production space. what are the proactive methods you can take ?

815


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

882