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 are fundamental stages of data warehousing?

Explain what is data validation strategies for data mart validation after loading process?

if you use oracle sql*loader , how do you transform data with it during loading?

Explain the structure of cold fusion?

What is the differences between star and snowflake schemas?

What is source qualifier?

What are vaious etl tools in the market?

Name at least three brands of Database Management Systems

What are session timeout and application timeout?

explain about dirty dimension?

how to find unique records in informatica level

What is conformed fact?

For more Data Warehouse General Interview Questions Click Here