Implementing Partitions

SQL Server 2014
  • 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
    FREE ACCESS
  • Locked
    4. 
    Creating a Local Partition By Filtering a Fact Table
    6m 26s
    FREE ACCESS
  • Locked
    5. 
    Creating a Local Partition Using Tables or Queries
    6m 17s
    FREE ACCESS
  • Locked
    6. 
    Setting up for Remote Partition Creation
    9m 53s
    FREE ACCESS
  • Locked
    7. 
    Creating Remote Partitions
    4m 3s
    FREE ACCESS
  • Locked
    8. 
    Enabling Write-Back in a Partition
    4m 20s
    FREE ACCESS
  • Locked
    9. 
    Browsing and Managing Write-Back Data in a Partition
    5m 34s
    FREE ACCESS
  • Locked
    10. 
    Designing Aggregations for a Partition Using the Wizard
    8m 28s
    FREE ACCESS
  • Locked
    11. 
    Editing and Deleting Partitions
    4m 48s
    FREE ACCESS
  • Locked
    12. 
    Merging Partitions
    7m 13s
    FREE ACCESS

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

COURSE BI Data Model Partitions
Likes 9 Likes 9  
COURSE Designing Multidimensional Models
Likes 7 Likes 7  
COURSE Data Warehousing with Azure: Working with SQL Data Warehouse Objects
Likes 9 Likes 9