Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive the max(sal),deptno,empno in datastage?
- 13 Answers
- 24360 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
How many types of stage?
What is the difference between the local container and shared container?
client know skid info?
Differentiate between operational datastage (ods) and data warehouse?
What are datastage sequences?
What is the project in datastage?
what is use of SDR function?
Difference between server jobs & parallel jobs?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is the difference between datastage and datastage tx?
Can you implement SCD2 using join, transformer and funnel stage?
what is the use of surogate key in datastage
Define orabulk and bcp stages?
What are the processing stages?
On which interface you will be working as a developer?
