Skip to contents

Creates a star_schema object from a flat table (implemented by a tibble) and a dimensional_model object.

Usage

star_schema(ft, sd)

Arguments

ft

A tibble, implements a flat table.

sd

A dimensional_model object.

Value

A star_schema object.

Details

Transforms the flat table data according to the facts and dimension definitions of the dimensional_model object. Each dimension is generated with a surrogate key which is a foreign key in facts.

Facts only contain measurements and foreign keys.

See also

dimensional_model

Other star schema and constellation definition functions: character_dimensions(), constellation(), role_playing_dimension(), snake_case()

Examples


st <- star_schema(mrs_age, dm_mrs_age)