Teradata Interview Questions
Questions Answers Views Company eMail

in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

HCL,

2 12541

write lock is compatiable with which type of lock?

Infosys,

6 6894

Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

Cap Gemini,

6 7804




suppose one Cylinder split data blocks are moved from where?

1 2464

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

IBM,

1550

i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80

CTS,

11 8832

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. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

1585

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?

Wipro, Bank Of America,

6 41240




Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

Cap Gemini,

4 7233

i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.

1 2675

What is the difference between SI and JI?

2 4648

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

Cap Gemini,

4 8088

I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 6289

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

TCS,

1 6902

how to delete duplicate records in multi set table without using any tables

Accenture, Nest, Spiro Solutions, South Nests Software Solution,

2 10226


Post New Teradata Questions






Un-Answered Questions { Teradata }

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

2347


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

694


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?

838


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

469


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

892






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

789


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

2015


If RDBMS is halted what will you do ?

917


how can we analyze the locks ?

886


what is sysdba and sysdbc ? which has high priority ?

2508


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

963


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

829


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

443


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

465


what are the day to day activities of teradata DBA ?

4059