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

Why we need datasets ratherthan sequential files?

5 Answers  


i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,


How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,


difference between server shared container and parallel shared container

6 Answers   CTS,


in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,






Difference between server jobs & parallel jobs?

0 Answers  


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,


what is meant by port ? what is the use of port ? what are the different type of ports and its usage

2 Answers   Accenture,


HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  


How did you reconcile source with target?

2 Answers   HP,


Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,


What is the difference between datastage and informatica?

0 Answers  


Categories