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 |
root tree will find which is server job and which is parallel job?
Differentiate between datastage and datastage tx?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
what is the use of DSattchJob?DetachJob? where can we find it?
what is use of SDR function?
how to change left and right links in join stage?
How can one find bugs in job sequence?
What are the different type of jobs in datastage?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
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
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
How do you find the number of rows in a sequential file?