Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9684 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 is the difference between server job and parallel jobs?
On which interface you will be working as a developer?
Name the different types of Lookups in Datastage?
How can we improve the performance in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
whom do you report?
Name the third party tools that can be used in datastage?
Differentiate between data file and descriptor file?
What a datastage macro?
How you Implemented SCD Type 1 & Type 2 in your project?
What is the difference between an operational datastage and a data warehouse?
Define project in datastage?
What is the difference between the local container and shared container?
What are the various kinds of containers available in datastage?
What is meta stage?
