how to calculate sum(sal) with out using aggregator satge
- 3 Answers
- 7762 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain differences between star and snowflake schemas?
I need to set predefined condition. How I do this?
Explain functional dependency?
Explain what is the difference between view filter and report filter?
What is data warehosuing hierarchy?
Explain what is full load & incremental or refresh load?
Explain what are the different types of join operations?
What are the other names given to data warehousing?
Can decision tree be implemented using SQL?
What is type 2 version dimension?
Difference between PowerPlay transformer and power play reports?
Give some difference between oltp and olap.
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Is there any default username & pwd for bo designer & supervisor?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
