Interested to Buy Any Domain ? << Click Here >> for more details...
hi my source is::
empno,deptno,salary
1, 10, 3.5
2, 20, 8
2, 10, 4.5
1, 30, 5
3, 10, 6
3, 20, 4
1, 20, 9
then target should be in below form...
empno,max(salary),min(salary),deptno
1, 9, 3.5, 20
2, 8, 4.5, 20
3, 6, 4, 10
can anyone give data flow in data stage for the above
scenario....
thanks in advance...
- 5 Answers
- 9674 Views
- I also Faced
- E-Mail Answers
Answer Posted / eswararao
create one group using column generator and then Using Aggregator stage select max sal,min sal
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Enlist various types of routines in datastage.
Describe stream connector?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are the features of datastage flow designer?
what are the errors,warnings in datastage
How many types of stage?
Can you implement SCD2 using join, transformer and funnel stage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What all the types of jobs you developed?
How you can fix the truncated data error in datastage?
What are the areas of application?
What is usage analysis in datastage?
How can we improve the performance in datastage?
how many rows sorted in sort stage by default in server jobs
