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

What is mean by aggregate aware?

1011

How do you create surrogate key using ab initio?

949

What are the tools available for etl?

935

What is the limit to the number of sources and targets you can have in a mapping?

1062

Explain what is ods (operation data source)?

937

What are loops in Datawarehousing?

955

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

913

Explain what is the difference between datawarehouse and bi?

916

Explain the difference between oltp and olap?

1067

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

882

How can you set the client management?

965

What is a functional dependency f said to be minimal?

995

List any five applications of data warehouse.

902

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1320

I need to set predefined condition. How I do this?

969