Teradata Interview Questions
Questions Answers Views Company eMail

Difference between Qualify and group

CTS,

4 11563

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

3 4062

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 5799




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 4109

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 5643

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

TCS,

4 7660

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 5295

What is meant by MATCHTAG in multiload utility?

Satyam,

2 5874




Hash collision?

Satyam,

3 7379

what is meant by Hot amp?

Satyam, IBM,

2 10127

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 6046

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 6300

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 4134

If RDBMS is halted what will you do ?

Teradata,

1082

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

Teradata,

1 3264


Post New Teradata Questions






Un-Answered Questions { Teradata }

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

1067


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

2489


Difference between stored procedure and macro?

9


What is meant by a node?

9


What are the multiload utility limitations?

8






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

849


How many tables can you join in v2r5?

7


In Teradata, how do we Generate Sequence?

9


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

2999


What is meant by a Clique?

11


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

7


Highlight a few of the advantages that ETL tools have over Teradata.

7


Different phases of multiload?

9


What is the use of having index's on table?

13


what are the day to day activities of teradata DBA ?

4477