how to calculate sum(sal) with out using aggregator satge
- 3 Answers
- 8416 Views
- HSBC, I also Faced
- E-Mail Answers
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 a data warehouse.
How to answer the question how many fakt table in your datawarehouse and what size it have?
What is the advantages data mining over traditional approaches?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
Explain conformed fact?
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
what is table partitioning? How it is useful to warehouse database?
what is the diffrence between psa and idoc
Explain the difference between oltp and olap?
What is meant by metadata in context of a data warehouse?
What is the differences between star and snowflake schemas?
Explain a mapping, session, worklet, workflow, mapplet?
Teradata 
