just sql override in SQ t/r: select col1..,sum(sal) from table

how to calculate sum(sal) with out using aggregator satge

Question Posted / jz

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

Please Help Members By Posting Answers For Below Questions

Explain the definition of normalized and denormalized view and what are the differences between them?

863

Explain hybrid slowly changing dimension?

960

What are different deliverables according to phases?

3322

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

881

What is the main difference between schema in rdbms and schemas in datawarehouse?

1020

How can you set the client management?

954

what is user variable in affinium campaign? and some real time examples.

4111

what are the major three types of modeling used?

1018

Explain about core dimension,

919

What is is a star schema?

1063

Why is chameleon method used in data warehouse?

1098

Explain clustering algorithm?

2208

What are the different models used in cluster analysis?

894

How to pivot data using informatica when you have variable amount of pivot rows?

856

List down some of the real time data-warehousing tools?

913