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...
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 job parameters?
how to implement scd2 in datastage 7.5 with lookup stage
What are transforms and what is the differenece between routines and transforms?
What is the command line function to import and export the ds jobs?
How do y read Sequential file from job control?
What is a folder? Difference types of stages?
Describe routines in datastage? Enlist various types of routines.
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the various kinds of containers available in datastage?
how many rows sorted in sort stage by default in server jobs
What are the steps required to kill the job in Datastage?
Can you explain tagbatch restructure operator?
How rejected rows are managed in datastage?
What are orabulk and bcp stages?
How do you reject records in a transformer?