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

Question Posted / aadi

Answers were Sorted based on User's Feedback

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

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

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

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

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

Answer / tejeswara rao potnuru

using expression transformation we can find

Is This Answer Correct ?

3 Yes

8 No

More Data Warehouse General Interview Questions

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

Do you view contain data?

Explain what is the difference between a primary and secondary actor in use case modeling?

What is defined as partial backup?

What are the primary ways to store data in OLAP?

Compare and contrast aggregates & indexes

how much memory space occupied real time project (roughly)?

What are the different types of join operations?

What are non-additive facts in detail?

What are algorithms provided by Microsoft in SQL Server?

What needs to be done while starting the database?

For more Data Warehouse General Interview Questions Click Here