dereference_dimension

dereference_dimension.fact_table

A <code>dimension_table</code> object.

dimension

A boolean, indicates whether the attributes need to be
transformed.

conversion

Given a dimension, transform the fact table so that the primary key of the
dimension (which is a foreign key in the fact table) is replaced by the other
attributes of the dimension.

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.

dereference_dimension: Dereference a dimension

Description

Usage

Arguments

Value