Interested to Buy Any Domain ? << Click Here >> for more details...
my soure table is emp having columns sal,deptno in the
deptno 10,20,30deptno row are there expected out
put is min(sal) of 10th deptno,max(sal) of 20th
deptno,mean(sal) of 30th deptno using aggregation stage
- 4 Answers
- 8077 Views
- I also Faced
- E-Mail Answers
Answer Posted / farzana kalluri
Take source--->copy.from copy take 3 links for 3
aggregators and then filter from filter take 3 links for 3
targets..In filter mention deptno...
1.key=deptno=10
In agg column for calculation=sal
options: max(sal)
2.key=deptno=20
column for calculation=sal
options:min(sal)
3.key=deptno=30
column for calculation=sal
options:mean(sal)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How you Implemented SCD Type 1 & Type 2 in your project?
Demonstrate experience in maintaining quality process standards?
How one source columns or rows to be loaded in to two different tables?
What are routines in datastage?
Explain ibm infosphere information server and highlight its main features?
What is oci?
To see hidden files in LINIX?
Define Merge?
how to sort two columns in single job in datastage.
What is the difference between operational data stage (ods) and data warehouse?
Differentiate between datastage and informatica?
How will you move hashed file from one location to another location?
Can you explain tagbatch restructure operator?
What is quality stage?
What is the use of hoursfromtime() function in transformer stage in datastage?
