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

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,


how can u find out the datastage job is running on how many nodes

7 Answers   IBM,


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

0 Answers   Wipro,


What is a range lookup?

2 Answers   IBM,


how to sort two columns in single job in datastage.

0 Answers   TCS,






3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  


which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,


Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,


i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  


WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,


what is a force compile

2 Answers   Cap Gemini, IBM,


source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,


Categories