ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Teradata
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
How to find No. of Records present in Each AMP or a Node 
for a given Table through SQL?
 Question Submitted By :: Hardeep
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
Answer
# 1
Sel HASHAMP(HASHBUCKET(HASHROW(PRIMARY_INDEX_COLUMNS))) 
 AS AMP_NO,
 COUNT(*) 
From DATABASENAME.TABLE_NAME
 GROUP BY 1;
 
Is This Answer Correct ?    12 Yes 2 No
N
 

 
 
 
Other Teradata Interview Questions
 
  Question Asked @ Answers
 
I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com IBM4
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.  2
What are two examples of an OLTP environment?  1
How a Referential integrity is handled in Teradata?  2
How does indexing improve query performance? Satyam3
What are the types of tables in Teradata Infosys8
Does SDLC changes when you use Teradata instead of Oracle?  1
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.  5
what is the difference between bpo and call centre? American-Solutions1
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?  2
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ? IBM3
I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.  1
Increasing no of amps will increase performance. Is this true?  1
What is Join Index in TD and How it works? TCS1
Explain about Skew Factor?  4
Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me TCS2
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?  1
Can we load a Multi set table using MLOAD?  1
What is use of compress in terdata?Explain?  3
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?  2
 
For more Teradata Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com