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
How will you move hashed file from one location to another location?
How can you write parallel routines in datastage PX?
How many types of stage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How do you start developing a datastage project?
Explain the importance of surrogate key in data warehousing?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How and where you used hash file?
What is the importance of the exception activity in datastage?
Name the different types of Lookups in Datastage?
Nls stands for what in datastage?
root tree will find which is server job and which is parallel job?
Differentiate between operational datastage (ods) and data warehouse?
What could be a data source system?
how many rows sorted in sort stage by default in server jobs