how to retrive the max(sal),deptno,empno in datastage?
Answer Posted / guest
we can retrive the max(sal),deptno,empno in aggreator stage.
way is
set group=deptno
aggregator type=calculation
column for calculation=sal
max value output column=max(sal)
Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
Explain datastage architecture?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how to write server Routine coding?
What is a folder? Difference types of stages?
What steps should be taken to improve Datastage jobs?
How complex jobs are implemented in datstage to improve performance?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
explain about citrix scheduling tool in datastage
State the difference between an operational datastage and a data warehouse?
How do you generate sequence number in datastage?
How to convert RGB Value to Hexadecimal values in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the importance of the exception activity in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How can you write parallel routines in datastage PX?