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 |
Describe the differences between a data warehouse and data mart.
What does level of granularity of a fact table signify?
Hi Cognos Folks, I have all cognos certification dumps. In fact i am certified in most of the dumps recently. I have cognos material, pdfs, user guides, documents along with dumps. If any one required cognos dumps, please drop me mail at cognos.biuser@gmail.com Thanks, Cognos bi user
How to use the tool Ontobulider
What is mean by aggregate aware?
What are fundamental stages of data warehousing?
What are fact, dimension, and measure?
Explain conformed fact?
Explain what are the different types of data warehousing?
What are vaious etl tools in the market?
Which are the olap tools available that are supported by oracle?
What is MODEL is Data mining world?