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
- 9879 Views
- I also Faced
- E-Mail Answers
Answer Posted / lakshmi srinivas
source->copy->2 aggregators->join->target
1 aggregator->eno,max(sal),min(sal)
2 aggregator->eno,dno,max(sal)
by using max(sal) key, we can join both o/p of
aggregators,we can get that output...
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
AGGREGATOR default datatype
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are stage variables and constants?
What are iconv and oconv?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
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
how to add a new records into source?
Can you define merge?
What is the difference between orabulk and bcp stages?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How a server job can be converted to a parallel job?
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
What is the importance of the exception activity in datastage?
Can you highlight the main features of ibm infosphere information server?
