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 |
Explain what is the metadata extension?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What are the differences between star and snowflake schema?
What is dimension modeling?
What are the types of dimensional modeling?
Explain what is cost benefit analysis (cba)?
Explain what is the difference between power center & power mart?
Explain can report net connect multiple datasource at a time in report creation time?
Explain is fact table?
Where we use surrogate key explain with example?
What is cubes?
how do you use commit frequencies? how does it affect loading performance?