Create and Maintain Facts

To download Dimodelo Data Warehouse modeler visit the product page.

This 4 minute video demonstrates

  • Creating a new Fact table,
  • Importing its schema from a source system,
  • Associating the Fact with its Dimensions, including role-plays,
  • and deploying to the Development server.

After reviewing the deployed table, the video demonstrates making changes to columns of the table and storage properties like columnstore and indexes.

To see how to make mass changes across all Fact tables please view the Mass Changes lesson.