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
What are the important features of datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the difference between in process and inter process?
What is the sortmerge collector?
what is the use of surogate key in datastage
whom do you report?
How do you import and export the datastage jobs?
What are constraints and derivations?
How many types of sorting methods are available in datastage?
Differentiate between data file and descriptor file?
What is the difference between an operational datastage and a data warehouse?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How to read the length of word in unix?
Is it possible to query a hash file?
What are sequencers?