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
- 9679 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
What are the different common services in datastage?
Which warehouse using in your datawarehouse
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the steps needed to create a simple basic datastage job?
how to sort two columns in single job in datastage.
Define oconv () and iconv () functions in datastage?
How we can covert server job to a parallel job?
What is the difference between in process and inter process?
Lookup constraints
Why we use surrogate key?
what is the use of skid in reporting?
What is a datastage job?
How to manage date conversion in Datastage?
What is the difference between hashfile and sequential file?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
