Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive the max(sal),deptno,empno in datastage?
- 13 Answers
- 24518 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
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the difference between datastage and datastage tx?
How to clean the datastage repository?
How can one find bugs in job sequence?
Explain Quality stage?
What are the steps needed to create a simple basic datastage job?
Define Job control?
explain about citrix scheduling tool in datastage
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Explain ibm infosphere information server and highlight its main features?
How to find value from a column in a dataset?
What are the differences between datastage and informatica?
What is usage analysis in datastage?
Give an idea of system variables.
what is the custome stage in datastage? how can we impliment that one? plz tell me
