Build Data Warehouse Schemas with Dispec Loomer

Data warehouse models in minutes instead of weeks

Building a data warehouse is traditionally expensive, complex, and time-consuming. Data must be modeled, normalized, historized, and transferred into fact and dimension tables. On top of that come manual SQL scripts, schema adjustments, and continuous source system changes.

Dispec Loomer revolutionizes this process.

With Loomer, you can build complete DWH schemas including automated loading in minutes, not weeks.

Supported databases

Dispec Loomer supports DWH structures for:

• Microsoft SQL Server
• PostgreSQL
• Oracle
• MySQL

All features are available fully in each of these systems.

Automatically generate fact and dimension tables

Dispec Loomer creates complete star schemas:

• Fact tables
• Dimension tables
• SCD1 dimensions (current values)
• SCD2 dimensions (historized values)

For SCD2, Loomer automatically creates:

• Surrogate keys
• Valid history rows
• Correct references to the currently valid record

This gives you a professional, production-ready data warehouse without writing a single line of SQL.

Normalized or denormalized sources - both are possible

Your source data can be:

• Normalized (3NF)
• Denormalized (flat file, Excel, CSV, export from domain systems)

Dispec Loomer can generate from this either:

• A fully normalized DWH schema
• Or a classic star schema with fact and dimension tables

You define the target model - Loomer handles the technical implementation.

Automatic schema extension on structural changes

A common challenge in DWH projects is that the source structure changes: new columns, changed data types, additional attributes.

Dispec Loomer detects these changes automatically and:

• Adds missing columns in the DWH
• Adjusts data types
• Extends dimensions and facts
• Keeps the full schema stable and consistent

Important: Structures are never deleted, only extended.

This keeps all consuming systems such as Power BI operational at all times.

The fabric principle: keep data as unchanged as possible

Dispec Loomer follows the fabric principle:

• Data is transferred as unchanged as possible
• Transformations are used consciously and sparingly
• Data quality remains transparent and traceable

Why is this important?

Most data quality issues originate in source systems. If data is transferred 1:1, errors can be found faster, analyzed cleanly, and fixed sustainably.

If transformation issues occur, the Loomer Runtime shows them in detailed logs, including affected rows and fields.

DWH creation in 5 steps

1. Select source: Normalized or denormalized - Loomer detects structure automatically.
2. Define target model: SCD1, SCD2, star schema, or 3NF.
3. Generate tables: Loomer creates all fact and dimension tables automatically.
4. Configure load processes: Delta, full load, or historization.
5. Start transformation: Loomer Runtime handles SQL generation, loading, and logging.

Why Dispec Loomer is ideal for DWH projects

• DWH schemas in minutes instead of weeks
• Automatic historization (SCD2)
• Automatic surrogate keys
• Automatic schema extension
• Stable structures for BI tools
• No SQL skills required
• Reproducible and transparent processes

Dispec Loomer makes data warehouse engineering faster, more cost-effective, and more reliable than traditional ETL processes.