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.