Teradata Interview Questions
Questions Answers Views Company eMail

Difference between Qualify and group

CTS,

4 15995

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

3 6338

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 8542

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 5968

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

Cap Gemini, IBM, Infosys,

2 8300

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

TCS,

4 10400

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 7265

What is meant by MATCHTAG in multiload utility?

Satyam,

2 8322

Hash collision?

Satyam,

3 9889

what is meant by Hot amp?

IBM, Satyam,

2 13159

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 10149

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 10173

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 5998

If RDBMS is halted what will you do ?

Teradata,

1918

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

Teradata,

1 4575


Post New Teradata Questions

Un-Answered Questions { Teradata }

What is the purpose of upsert command?

827


What is the purpose of joins in teradata and what are the available join types?

784


What do high confidence, low confidence and no confidence mean in explain plan?

818


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

860


How will you solve the problem that occurs during update?

810


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

1787


What is primary index and secondary index?

807


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

846


What are default access rights in teradata? What explicit right can be given to a user?

885


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

844


What are the multiload utility limitations?

805


Explain PDE.

846


What are the various indexes in teradata?

787


What is the opening step in basic teradata query script?

803


Explain Teradata performance tuning and optimization?

934