Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive the max(sal),deptno,empno in datastage?
- 13 Answers
- 23998 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / subbuchamala
SRC--> COPY stage--> 2 o/p links from COPY Stage-->
one is --> AGGREGATOR and other is --> JOIN-->TGT
-->In AGG Stage:
set group=DEPNO
aggregator type=calculation
column for calculation=SAL
max value output column=SAL
-->O/P of AGG Stage:
SAL(max(sal), DEPNO
-->In JOIN stage:
Inner Join on DEPNO and SAL and get the EMPNO as well.
By doing this, we get Max(sal) of the employee on particular DEPNO.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you register plug-ins?
What is the difference between datastage and informatica?
EXPLAIN SCD
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
How a routine is called in datastage job?
What steps should be taken to improve Datastage jobs?
What is the differentiate between data file and descriptor file?
What are sequencers?
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)
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What are the various kinds of containers available in datastage?
How to implement complex jobs in data stage?
