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 with a dimension key. 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.