The Datavault Builder is able to virtually output any data in dimensional or snowflake format. As storage and presentation are split, you don’t need to reload your dimensional model just because you want to add one more column.
Addtionally you can output the data in 3NF, flat table or data product format.
Module | Feature | Supported |
|---|---|---|
Dimensional Model | Visually select from the whole model | Yes |
Dimensional Model | Select from hubs, links, satellites and link satellites | Yes |
Dimensional Model | Automatically denormalize business objects (facts and dimensions) | Yes |
Dimensional Model | Automatic grain checks | Yes |
Dimensional Model | Visual consolidation of data | Yes |
Dimensional Model | Visual harmonization of column names | Yes |
Dimensional Model | Taking care of all necessary join operations without writing one line of code | Yes |
Dimensional Model | Automatically evaluate tracking satellites | Yes |
Dimensional Model | Either output all keys from a hub or only keys relating to a specific source | Yes |
Dimensional Model | Automatic protection against fanning | Yes |
Dimensional Model | Select Attributes by Drag and Drop | Yes |
Dimensional Model | Rename Columns | Yes |
Dimensional Model | Automatic Refactoring | Yes |
Dimensional Model | Select as-of-now (SCD type 1) or as-of-then (SCD Type 2) output | Yes |
Dimensional Model | Automatically create PIT tables if necessary | Yes |
Dimensional Model | Automatically join several PIT tables if necessary | Yes |
Dimensional Model | Automatic versioning in the logfile | Yes |
Dimensional Model | Versioning trough GIT possible | Yes |
Dimensional Model | Validate functioning of all dependent objects on changes | Yes |
Dimensional Model | Rebuild automatically all dependent objects on changes | Yes |
Dimensional Model | Preview data | Yes |
Dimensional Model | Multi column selects | Yes |
Dimensional Model | Self Service BI ready | Yes |