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
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 |
Why we need datasets ratherthan sequential files?
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
How do y read Sequential file from job control?
difference between server shared container and parallel shared container
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?
Difference between server jobs & parallel jobs?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
HOW CAN WE SEE THE DATA IN DATASET?
How did you reconcile source with target?
Difference between the Sequence and Sequencer in DS?
What is the difference between datastage and informatica?