To create a LASR star
schema:
-
Select
LASR
Create a Star Schema.
-
Drag and drop tables
or data queries from the SAS Folders tree onto the workspace. Keep
the following suggestions in mind:
-
Drag and drop the fact table first
and then the dimension tables.
-
Any input tables that are not already
in a SAS LASR Analytic Server
library are loaded to memory when the star schema is run.
-
If a dimension table shows the
icon, then it usually indicates that the data builder
could not determine the join condition for the dimension table. Position
your pointer over the icon for information about how to correct the
incomplete table status.
-
(Optional) If you do
not want a column from the dimension table in the output table, select
the column in the table in the workspace, right-click, and select
Remove
Column.
Note: All of the columns from the
fact table are automatically selected and required to be included
in the output table.
-
(Optional) Click the
Joins tab
to review the columns that are used to generate the output table.
-
(Optional) Specify a
different column prefix.
For
more information, see Column Prefixes.
-
Click the
Output tab,
and specify a name for the output table.
-
Click
, and specify a name and location for the LASR star
schema.
-
Click
to generate the output table.