What is a LASR Star Schema?

A LASR star schema is very similar to a typical star schema in a relational database. Imagine a single fact table that is surrounded by dimension tables. Each dimension table is joined to the fact table using a dimension key.
Here are some key facts about LASR star schemas:
  • Typically, the dimension key and the corresponding column in the fact table are the same data type and length. If your tables do not use the same data type and length, then there are two ways to correct the data:
    • Change the data definition in the system with the original data.
    • Create a data query that modifies the columns and outputs the table to an in-memory table.
  • Single-level star schemas are supported. Snowflake schemas are not.
  • A LASR Star Schema is limited to a single join condition. It does not support multiple key columns between fact and dimension tables.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 8, 2019