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
- 9666 Views
- I also Faced
- E-Mail Answers
Answer Posted / pankaj das, orator
Just take...
source -> aggregate stage -> target
And then in aggregate stage in output tab just specify
col name groupby derivation
------- ------- ----------
id group by id
max_sal max(sal)
min_sal min(sal)
deptno deptno
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
Demonstrate experience in maintaining quality process standards?
Have you have ever worked in unix environment and why it is useful in datastage?
Why do we use link partitioner and link collector in datastage?
why do u need the IOS upgradation in a FC switch
What are the different plug-ins stages used in your projects?
Explain datastage architecture?
How do you import and export data into datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
On which Dimension Table you implemented SCD Type in your Project
What is the difference between validated and compiled in the datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
what is the use of materialized view?
How can we improve the performance in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the purpose of interprocessor stage in server jobs?
