What is the cumulative sum and moving sum?
devquora
Posted On: Feb 22, 2018
Cumulative sum is partial sums of a given column that can calculate by using CUME(COLUMN NAME).
moving sum returns the sum of a specifies set of rows. It ignores null values when calculating the moving sum so that if all values are NULL, Then the function Returns NULL
MONINGSUM(ROWNAME,Rowsetvalue)
moving sum returns the sum of a specifies set of rows. It ignores null values when calculating the moving sum so that if all values are NULL, Then the function Returns NULL
MONINGSUM(ROWNAME,Rowsetvalue)
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Informatica Interview Questions
In warehouses how many schemas are there?
There are four Schema’s They are: Star Schema Snow Flake Schema Galaxy Schema Fact Constellation Schema..
Informatica Interview Questions
Could you explain what is Enterprise data warehouse?
In enterprise data warehousing all organization data is created at a single point of access .data can be provided a glo..
Informatica Interview Questions
What is different between the data warehouse and data mart?
A Data Mart Is a simple form of a data warehouse that is focused on a single subject or functional areas such as sales..