Implementing Partitions

SQL Server 2014    |    Intermediate
  • 12 Videos | 1h 19m 4s
  • Earns a Badge
Likes 5 Likes 5
In SQL Server Analysis Services (SSAS), partitions are used to provide the physical storage for the fact data in a measure group. Discover how to design, create, and work with both local and remote partitions.

WHAT YOU WILL LEARN

  • describe partitions in a multidimensional model, including the types Local and Remote, aggregations, and design strategy
    describe the storage modes used for partitions, including MOLOP, ROLOP, HOLAP
    describe proactive caching for partitions
    create a local partition by filtering a fact table
    create a local partition using a table, view or named query
    setup the configuration for remote partitions, including specifying valid server names, creating and deploying a secondary database, and enabling features in SQL Server Management Studio (SSMS)
  • create a remote partition
    enable write-back on a partition in Cube Designer and  SQL Server Management Studio (SSMS)
    browse, delete, disable, and convert write-back data
    design aggregations for a partition using the Aggregation Design Wizard
    edit and delete partitions in a multidimensional model
    merge partitions in a multidimensional model

IN THIS COURSE

  • Playable
    1. 
    Designing a Partition Strategy
    5m 45s
    UP NEXT
  • Playable
    2. 
    Understanding the Storage Modes for Partitioning
    6m 54s
  • Locked
    3. 
    Understanding Proactive Caching for Partitions
    5m 24s
  • Locked
    4. 
    Creating a Local Partition By Filtering a Fact Table
    6m 26s
  • Locked
    5. 
    Creating a Local Partition Using Tables or Queries
    6m 17s
  • Locked
    6. 
    Setting up for Remote Partition Creation
    9m 53s
  • Locked
    7. 
    Creating Remote Partitions
    4m 3s
  • Locked
    8. 
    Enabling Write-Back in a Partition
    4m 20s
  • Locked
    9. 
    Browsing and Managing Write-Back Data in a Partition
    5m 34s
  • Locked
    10. 
    Designing Aggregations for a Partition Using the Wizard
    8m 28s
  • Locked
    11. 
    Editing and Deleting Partitions
    4m 48s
  • Locked
    12. 
    Merging Partitions
    7m 13s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE