how to retrive the max(sal),deptno,empno in datastage?
- 13 Answers
- 20822 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / guest
we can retrive the max(sal),deptno,empno in aggreator stage.
way is
set group=deptno
aggregator type=calculation
column for calculation=sal
max value output column=max(sal)
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
Can you explain tagbatch restructure operator?
How to perform incremental load in datastage?
What is ibm datastage?
Terminate Activity
I have a few records just I want to store data in to targets cycling way how?
Nls stands for what in datastage?
Enlist various types of routines in datastage.
What is quality stage?
What are the primary usages of datastage tool?
How a routine is called in datastage job?
What is the purpose of pivot stage?
How to reverse the string using SQL?
How do you run datastage job from the command line?
Define orabulk and bcp stages?
How many types of sorting methods are available in datastage?
