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 / 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
Can you explain kafka connector?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is the difference between orabulk and bcp stages?
How to perform incremental load in datastage?
What are the partitioning techniques available in link partitioner?
What are the benefits of datastage?
What are stage variables, derivations and constants?
Differentiate between operational datastage (ods) and data warehouse?
Where do you see different stages in the designer?
AGGREGATOR default datatype
What is the differentiate between data file and descriptor file?
how can we create rank using datastage?what is the meaning of rank?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Nls stands for what in datastage?
What are the main features of datastage?