incremental_refresh_star_schema: Incrementally refresh a star schema with another

In josesamos/starschemar: Obtaining Stars from Flat Tables

Incrementally refresh a star schema with another

Description

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 class '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.

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".

Value

A star_schema object.

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")

josesamos/starschemar documentation built on May 6, 2024, 5:57 a.m.