Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

count number of deptno in a emp table?

Answer Posted / naganji mandru

Using aggrgator one way,Another way write query from database stage like

Select deptno,count(*) as c from emp group by deptno

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2204


Explain Quality stage?

1141


How to reverse the string using SQL?

1494


How to read multiple files using a single datastage job if files have the same metadata?

1219


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2488


What is ds designer?

1078


How can we improve performance of data stage jobs?

999


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3317


What are the steps needed to create a simple basic datastage job?

1213


What is the difference between server job and parallel jobs?

1134


Can you highlight the main features of ibm infosphere information server?

1077


how do u catch bad rows from OCI stage? And what CLI stands for?

2787


How to convert RGB Value to Hexadecimal values in datastage?

3981


What are the different types of lookups in datastage?

1045


What are the primary usages of datastage tool?

1057