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 / nish

use aggregator stage: Group by Deptno.
In the calculation field: select RecCount

this will create a new column with count of deptno. Make sure to map to the output stage.

Hope this helps your poorly framed question.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between odbc and drs stage?

1051


How many types of stage?

1181


How many types of views are there in a datastage director?

1296


What are the benefits of datastage?

1238


What are the different type of jobs in datastage?

1043


What is a merge?

1171


What is oci?

1303


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2483


What are the types of containers and how to create them?

980


What is a quality stage in datastage tool?

1079


What is the difference between odbc and drs stage?

1092


What are some prerequisites for datastage?

1100


What is meta stage?

1185


Define project in datastage?

1100


What are the steps required to kill the job in Datastage?

1218