how to calculate sum(sal) with out using aggregator satge
Answers were Sorted based on User's Feedback
Answer / jz
just sql override in SQ t/r:
select col1..,sum(sal) from table_nme group by (col)
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / dj
we have to add 2 new ports in "expression"
1)variable-- declare sum(sal)
2)output port- cal this variable
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / tejeswara rao potnuru
using expression transformation we can find
| Is This Answer Correct ? | 3 Yes | 8 No |
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What are necessary tasks to install reportnet software?
What is the purpose of Dataware Control?
What is data stream and data adaopter?
what type of raid setup would you put your tx logs?
What is a relationship?
What is a source qualifier?
Why denormalization is promoted in universe designing?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What is factless fact schema?
What is your spectra photometer working principles?
What is the difference between data warehouse and operational systems?