WHAT IS A OLAP IN DATA WAREHOUSE?

OLAP is nothing but Online Analytical Processing and these tools are called as reporting Tools Also

A OLAP Developer analyses the data ware house and generate reports based on selection criteria.

It contain the history data and the data is in the form of normalized.

It contain the more no.of Joins

There are several OLAP Tools are available

  1. Business Objects
  2. Cognos
  3. Report Net
  4. SAS
  5. Micro Strategy
  6. Hyperion
  7. MSAS (Microsoft Analysis Services)
Related Posts Plugin for WordPress, Blogger...

Be the first to comment

Leave a Reply

Your email address will not be published.


*