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 Posted / 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 View All Answers
Is it possible to query a hash file?
Can you explain kafka connector?
How to RD using transformer?
What is ibm datastage?
What is a ds designer?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How to read multiple files using a single datastage job if files have the same metadata?
How do u convert the columns to rows in datastage?
what is the difference between == and eq in UNIX shell scripting?
What is the sortmerge collector?
What are the different common services in datastage?
Differentiate between validated and Compiled in the Datastage?
Describe the architecture of datastage?
How a server job can be converted to a parallel job?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do