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
- 9597 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
On which Dimension Table you implemented SCD Type in your Project
State the difference between an operational datastage and a data warehouse?
How to read multiple files using a single datastage job if files have the same metadata?
What are the types of hashed files in data stage
What are routines in datastage?
Define Job control?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is use Array size in datastage
What is the use of hoursfromtime() function in transformer stage in datastage?
Can you define merge?
Where do the datastage jobs get stored?
What is active and passive stage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
How a source file is populated?
