Interested to Buy Any Domain ? << Click Here >> for more details...
how to calculate sum(sal) with out using aggregator satge
- 3 Answers
- 9288 Views
- HSBC, I also Faced
- E-Mail Answers
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 indexing ? what are different types of indexes supported by oracle ?
How to pivot data using informatica when you have variable amount of pivot rows?
What is the difference between snowflake and star schema?
How to drill through from a powerplay cube to reportnet?
Explain can a dimension table contains numeric values?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What is multi-dimensional analysis?
What is the difference between olap and datawarehosue?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.
Explain what are non-additive facts?
What are the different types of fact tables used in data warehousing?
Teradata 
