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...
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 is the difference between datastage and informatica?
What is meta stage?
Can you explain tagbatch restructure operator?
What are the areas of application?
What are some different alternative commands associated with "dsjob"?
What are the processing stages?
What is a merge?
What is a quality stage in datastage tool?
What are the benefits of datastage?
What is the purpose of pivot stage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is job control?
What are data elements?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How to implement complex jobs in data stage?