update_facts_with_role_dimension

Update facts with a role 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 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 of this package is to define transformations that allow
obtaining stars from flat tables easily. In addition, it includes
basic data cleaning, dimension enrichment, incremental data refresh
and query operations, adapted to this context.

Jose Samos

starschemar

Obtaining Stars from Flat Tables

Universidad de Granada 

update_facts_with_role_dimension function

<dl><dt>st</dt>
<dd>A <code>star_schema</code> object.</dd>
<dt>name</dt>
<dd>A string, name of the dimension.</dd>
<dt>old_dimension</dt>
<dd>A <code>dimension_table</code> object.</dd>
<dt>dimension</dt>
<dd>A <code>dimension_table</code> object.</dd>
<dt>dimension_names</dt>
<dd>A vector of dimension names.</dd></dl>

Arguments

Update facts with a role dimension — update_facts_with_role_dimension

<dl>

<dt>st</dt>
<dd>A <code>star_schema</code> object.</dd>


<dt>name</dt>
<dd>A string, name of the dimension.</dd>


<dt>old_dimension</dt>
<dd>A <code>dimension_table</code> object.</dd>


<dt>dimension</dt>
<dd>A <code>dimension_table</code> object.</dd>


<dt>dimension_names</dt>
<dd>A vector of dimension names.</dd>

</dl>

update_facts_with_role_dimension: Update facts with a role dimension

Description

Usage

Value

Arguments