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

What is the extension of file to save template?

How does data mining and data warehousing work together?

Best institute for MS BI training in Hyderabad, India?

how do you use commit frequencies? how does it affect loading performance?

Explain what are the basic needs to join two sources in a source qualifier?

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

What is operational data source (ODS)?

What is confirmed dimension?

Explain normalization?

What is meant by metadata in context of a data warehouse and how it is important?

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

For more Data Warehouse General Interview Questions Click Here