Teradata Interview Questions
Questions Answers Views Company eMail

Difference between Qualify and group

CTS,

4 9788

Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....

3 3467

Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance

IBM,

5 5167




Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE

IBM,

2 3626

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

Infosys, Cap Gemini, IBM,

2 4645

I want to write one query How to get Matched records and unmatched records in table?

TCS,

4 6920

TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

TCS,

2 4789

What is meant by MATCHTAG in multiload utility?

Satyam,

2 5114




Hash collision?

Satyam,

3 6554

what is meant by Hot amp?

Satyam, IBM,

2 9122

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

Satyam,

8 5315

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table

Satyam,

6 5582

Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance

2 3681

If RDBMS is halted what will you do ?

Teradata,

888

If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?

Teradata,

1 2893


Post New Teradata Questions






Un-Answered Questions { Teradata }

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

1527


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

700


how can we analyze the locks ?

852


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

1910


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?

815






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

1262


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

2297


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

1963


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

799


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

936


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

432


If RDBMS is halted what will you do ?

888


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

424


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

401


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

992