hi my source is::
empno,deptno,salary
1, 10, 3.5
2, 20, 8
2, 10, 4.5
1, 30, 5
3, 10, 6
3, 20, 4
1, 20, 9
then target should be in below form...
empno,max(salary),min(salary),deptno
1, 9, 3.5, 20
2, 8, 4.5, 20
3, 6, 4, 10
can anyone give data flow in data stage for the above
scenario....
thanks in advance...
- 5 Answers
- 8046 Views
- I also Faced
- E-Mail Answers
Answer Posted / shar
the question framed wrong
it should have been
empno,dept,sal
1,10,9
1,10,8
1,10,7
2,20,7
2,20,8.5
2,20,9
3,30,4
3,30,6
then expecting an ans is correct
o/p
empno,max(sal),min(sal),deptno
1,9,7,10
2,9,7,20
3,6,4,30
---xx----
where as in the o/p of user's question
we have
empno,max(sal),min(sal),deptno
1,9,3.5,20
2,8,4.5,20
3,6,4,10
here empno=1 his max(sal)=9 from deptno 20 and min(sal)=3.5 then its deptno=? actually we r giving a correct information but client will get confused max(sal) and min(sal) r both from 20 or different departments.
-----xxx----
even though client is expecting the same output then laxmi answer is correct
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the repository tables in datastage?
How one source columns or rows to be loaded in to two different tables?
Why do you need stage variables?
What are routines in datastage? Enlist various types of routines.
Define meta stage?
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 is the difference between validated and compiled in the datastage?
What is the difference between in process and inter process?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is a ds designer?
What is size of a transaction and an array means in a datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is usage analysis in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are the functionalities of link partitioner?
