how to retrive the max(sal),deptno,empno in datastage?
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
Differentiate between validated and Compiled in the Datastage?
How to find value from a column in a dataset?
What is ds designer?
Where the datastage stored his repository?
table actions available in oracle connector?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are the functionalities of link partitioner?
What is the differentiate between data file and descriptor file?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is orabulk stage?
What are the types of containers?
What are routines in datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how