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...


input

Name Salay
Sam 10
Sam 30
Sam 20
Ram 40
Ram 50

Output should be

Name Salary Count
Sam 10 3
Ram 40 2

get min salary and count of name .


OutPut 2

Name Seq
Sam 1
Sam 2
Sam 3
Ram 1
Ram 2



input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name S..

Answer / srinivas

Take seq->Agg->seq
IN agg select grouping Key Group=Name
IN Aggregations select Column for Calculation = Salery
Sub properties - Select Minimum Value output - Minimum salery
Sum of weights output - count

For second output

seq-agg-xsfm-seq
group on Name and count rows , In xsfm apply Looping .

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Data Stage Interview Questions

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

0 Answers   IBM,


Differentiate between datastage and datastage tx?

0 Answers  


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,


what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,


what is use of SDR function?

0 Answers   CGI,


how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,


How can one find bugs in job sequence?

0 Answers  


What are the different type of jobs in datastage?

0 Answers  


IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,


hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,


source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,


How do you find the number of rows in a sequential file?

1 Answers  


Categories