Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4491 Views
- HCL, I also Faced
- E-Mail Answers
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
Define ds designer?
What is the difference between passive stage and active stage?
What is process model?
What are the various kinds of containers available in datastage?
What are the different plug-ins stages used in your projects?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How a source file is populated?
What is the difference between hashfile and sequential file?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is the purpose of interprocessor stage in server jobs?
Explain the importance of surrogate key in data warehousing?
How to clean the datastage repository?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How do you remove duplicate values in datastage?
What are sequencers?
