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
- 9878 Views
- I also Faced
- E-Mail Answers
Answer Posted / pankaj das, orator
Just take...
source -> aggregate stage -> target
And then in aggregate stage in output tab just specify
col name groupby derivation
------- ------- ----------
id group by id
max_sal max(sal)
min_sal min(sal)
deptno deptno
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
How can you write parallel routines in datastage PX?
Define data aggregation?
How to find value from a column in a dataset?
whom do you report?
What are the functionalities of link partitioner?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are orabulk and bcp stages?
Have you used Unstructured data?
What are the stages in datastage?
How one source columns or rows to be loaded in to two different tables?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the flow of loading data into fact & dimensional tables?
