Skip to contents

Incrementally refresh a star schema with another

Source: R/star_schema_incremental_refresh.R
incremental_refresh_star_schema.Rd

Incrementally refresh a star schema with the content of a new one that is integrated into the first.

Usage

incremental_refresh_star_schema(st, st_new, existing = "ignore")

# S3 method for star_schema
incremental_refresh_star_schema(st, st_new, existing = "ignore")

Arguments

st

A star_schema object.

st_new

A star_schema object.

existing

A string, operation to be performed with records in the fact table whose keys match.

Value

A star_schema object.

Details

Once the dimensions are integrated, if there are records in the fact table whose keys match the new ones, new ones can be ignored, they can be replaced by new ones, all of them can be grouped using the aggregation functions, or they can be deleted. Therefore, the possible values of the existing parameter are: "ignore", "replace", "group" or "delete".

See also

Other incremental refresh functions: filter_fact_rows(), get_star_schema(), get_star_schema_names(), incremental_refresh_constellation(), purge_dimensions_constellation(), purge_dimensions_star_schema()

Examples


st <- st_mrs_age |>
  incremental_refresh_star_schema(st_mrs_age_w10, existing = "replace")

st <- st_mrs_cause |>
  incremental_refresh_star_schema(st_mrs_cause_w10, existing = "group")