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
- 8240 Views
- I also Faced
- E-Mail Answers
Answer Posted / percy
use aggregator stage in that perform first keycolumn as 10
and give calculation for sal as min sal
next take as 20 as key column maxsal for calculation same
as 30th dept
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are data elements?
Explain datastage architecture?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Explain connectivity between datastage with datasources?
What is difference between symmetric multiprocessing and massive parallel processing?
How do y read Sequential file from job control?
What all are the different way to run a job?
Explain how a source file is populated?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How complex jobs are implemented in datstage to improve performance?
what is repositery?
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.
Differentiate between datastage and informatica?
Name the different types of Lookups in Datastage?
how to implement scd2 in datastage 7.5 with lookup stage
