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
- 9468 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 types of containers in datastage?
Can you explain engine tier in information server?
sed,awk,head
What are the different plug-ins stages used in your projects?
What are the components of datastage?
What is the importance of the exception activity in datastage?
What are the types of containers?
What is the method of removing duplicates, without the remove duplicate stage?
What are the different layers in the information server architecture?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
what is the use of materialized view?
AGGREGATOR default datatype
What is a merge?
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
Whats difference betweeen operational data stage (ods) and data warehouse?
