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
- 9605 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
What are the important features of datastage?
Explain connectivity between datastage with datasources?
Which commands are used to import and export the datastage jobs?
how can we create rank using datastage?what is the meaning of rank?
What are the various kinds of the hash file?
Difference between data warehousing and olap?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
explain about citrix scheduling tool in datastage
What are the different plug-ins stages used in your projects?
Can you explain tagbatch restructure operator?
How a routine is called in datastage job?
Differentiate between odbc and drs stage?
how to export or import the jobs in .ISX file
Explain the situation where you have applied SCD in your project?
sed,awk,head
