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

Terminate Activity

1284


What are system variables and sequencers in datastage

1117


Whats difference betweeen operational data stage (ods) and data warehouse?

1116


Why we use surrogate key?

1238


What is the use of hoursfromtime() function in transformer stage in datastage?

1070


What are the features of datastage flow designer?

1041


What is the difference between hashfile and sequential file?

1262


How a server job can be converted to a parallel job?

1096


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3126


What all the types of jobs you developed?

1181


What are the different layers in the information server architecture?

1128


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213


How to reverse the string using SQL?

1536


root tree will find which is server job and which is parallel job?

1969


What are the repository tables in datastage?

1309