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
- 4597 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
Differentiate between Join, Merge and Lookup stage?
To see hidden files in LINIX?
What is difference between join, merge and lookup stage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Nls stands for what in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the types of containers in datastage?
What are the partitioning techniques available in link partitioner?
What are routines in datastage?
What are the important features of datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How many types of stage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
