replace_dimension_in_facts

replace_dimension_in_facts.star_schema

A <code>star_schema</code> object.

name

A <code>dimension_table</code> object.

dimension

set_type_conformed

This operation can be due to integrating several dimensions in a
constellation or an incremental update of a dimension (indicated with the
boolean parameter). The new dimension replaces in facts the original
dimension, whose name is indicated.

internal

Data in multidimensional systems is obtained from
operational systems and is transformed to adapt it to the new
structure. Frequently, the operations to be performed aim to
transform a flat table into a star schema. Transformations can
be carried out using professional ETL (extract, transform and
load) tools or tools intended for data transformation for end
users. With the tools mentioned, this transformation can be
carried out, but it requires a lot of work. The main objective
this package is to define transformations that allow obtaining
star schemas from flat tables easily. In addition, it includes
basic data cleaning, dimension enrichment, incremental data
refresh and query operations, adapted to this context.

replace_dimension_in_facts: Replace in facts a star schema dimension

Description

Usage

Arguments

Value