starschemar (version 1.2.0)

incremental_refresh_constellation: Incrementally refresh a constellation with a star schema

Description

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

Usage

incremental_refresh_constellation(ct, st, existing = "ignore")

# S3 method for constellation incremental_refresh_constellation(ct, st, existing = "ignore")

Arguments

ct

A constellation object.

st

A star_schema object.

existing

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

Value

A constellation 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_names(), get_star_schema(), incremental_refresh_star_schema(), purge_dimensions_constellation(), purge_dimensions_star_schema()

Examples

Run this code
# NOT RUN {
library(tidyr)

ct <- ct_mrs %>%
  incremental_refresh_constellation(st_mrs_age_w10, existing = "replace")

ct <- ct_mrs %>%
  incremental_refresh_constellation(st_mrs_cause_w10, existing = "group")

# }

Run the code above in your browser using DataLab