how to calculate sum(sal) with out using aggregator satge
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / dj
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 |
Answer / tejeswara rao potnuru
using expression transformation we can find
Is This Answer Correct ? | 3 Yes | 8 No |
What is incremintal loading?
Difference between PowerPlay transformer and power play reports?
What is the difference between drill through and masterdetail reports?
Explain what is power center repository?
Compare cold fusion with other programming languages?
What is the use of dimensional modeling in data warehousing?
What is the difference between snowflake and star schema?
Explain the differences between normalizer and normalizer transformation?
What is difference between model & package?
What is the difference between a data warehouse and a data mart?
15 Answers Apex, ASD Lab, Bank Of America,
What is drill-through?
What are the data types present in bo?