Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive the max(sal),deptno,empno in datastage?
- 13 Answers
- 24879 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / poornachandrababu.l
Hi, This is Poorna,
take a source and then copy stage,to copy stage 2 o/p links
one output is for aggregator and other for join.
In aggregator
set group=deptno
aggregator type=calculation
column for calculation=sal
max value output column=sal.
In Join stage do equee join based on deptno and sal .
And pass output of join Stage to target.
By doing this wasy we can get Max(sal) of the employee on
particular department.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Where do the datastage jobs get stored?
Which algorithm you used for your hashfile?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Name the different sorting methods in datastage.
how to abort the job its matain duplicates?
What is the purpose of interprocessor stage in server jobs?
How you can fix the truncated data error in datastage?
What is a datastage job?
What are the types of hashed files in data stage
What is aggtorec restructure operator?
What is the difference between passive stage and active stage?
How to find value from a column in a dataset?
What are some different alternative commands associated with "dsjob"?
Can you explain engine tier in information server?
What is use Array size in datastage
