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
- 9876 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
Define oconv () and iconv () functions in datastage?
What is a ds designer?
Why do we use link partitioner and link collector in datastage?
What are the types of hashed files in data stage
explain about citrix scheduling tool in datastage
what is the use of surogate key in datastage
Differentiate between datastage and datastage tx?
How to find value from a column in a dataset?
sed,awk,head
What are the some differences between 7.x and 8.x version of datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Which algorithm you used for your hashfile?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Can you highlight the main features of ibm infosphere information server?
what are the errors,warnings in datastage
