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
- 9893 Views
- I also Faced
- E-Mail Answers
Answer Posted / eswararao
create one group using column generator and then Using Aggregator stage select max sal,min sal
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Explain how a source file is populated?
How to convert RGB Value to Hexadecimal values in datastage?
How we can covert server job to a parallel job?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Why fact table is in normal form?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How to reverse the string using SQL?
Explain ibm infosphere information server and highlight its main features?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Define oconv () and iconv () functions in datastage?
describe the Steps to confiure a Qlogic switch
What is a merge?
Which commands are used to import and export the datastage jobs?
If you want to use a same piece of code in different jobs, how will you achieve this?
Describe stream connector?
