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

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE

What are the advantages of cold fusion?

Explain what is power center repository?

Explain what is partitioning? What are the types of partitioning?

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

what is parallel query?

what is Materialized Views?

Where the applications and where

How can we do ETL process in SQL Server?

Explain some of modeling tools available in the market?

What is the difference between power center and power mart?

Explain what are the various reporting tools in the market?

For more Data Warehouse General Interview Questions Click Here