Dimension and fact table creation using templates
A method of creating a dimension table or a fact table for a data warehouse includes accessing an ordered sequence of activities that are arranged in a template. A first set of code associated with creating the dimension table is organized into a dimension processing class, a second set of code asso...
Gespeichert in:
1. Verfasser: | |
---|---|
Format: | Patent |
Sprache: | eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | A method of creating a dimension table or a fact table for a data warehouse includes accessing an ordered sequence of activities that are arranged in a template. A first set of code associated with creating the dimension table is organized into a dimension processing class, a second set of code associated with creating the fact table is organized into a fact processing class, and a third set of code associated with creating both the dimension table and the fact table is organized into a common processing class. The method further includes executing the ordered sequence of activities and creating the dimension table when an instance of the dimension processing class is created in the ordered sequence of activities and creating the fact table when an instance of the fact processing class is created in the ordered sequence of activities. |
---|