Welcome to Astera DW Builder Documentation!

Getting Started

• Astera Data Warehouse Builder 10 – System Requirements
• Installing Client and Server Applications
• Connecting to a Server from the Client
• Building a Cluster Database and Creating a Repository
• Logging in from the Client
• Unlocking With a License Key
• Creating a Data Warehousing Project

Data Models

• Introduction to Data Models
• Opening a New Data Model
• Data Modeler – UI Walkthrough
• Reverse Engineering an Existing Database
• Creating a Data Model from Scratch
• General Entity Properties
• Creating and Editing Entity Relationships
• Forward Engineering
• Verifying a Data Model

Dimensional Modeling

• Introduction to Dimensional Modeling
• Converting a Data Model to a Dimensional Model
• Fact Entities
• Dimension Entities
• Placeholder Dimension for Early Arriving Facts and Late Arriving Dimensions
• Date and Time Dimension
• Verifying a Dimensional Model

Data Vault

• Introduction to Data Vaults
• Aggregates in Dimensional Modeling
• Data Vault Automation
• Raw Vault Entities
• Relationship Manager
• View Based Deployment
• Virtual Primary Key
• Virtual Relationships
• Change Field Properties

Documentation

• Generating Technical and Business Documentation for Data Models
• Lineage and Impact Analysis

Deployment & Usage

• Deploying a Data Model
• Validate Metadata and Data Integrity
• Using Astera Data Models in ETL Pipelines
• Connecting an Astera Data Model to a Third-Party Visualization Tool

Dataflows

• Introduction to Dataflows
• Data Model Query
• Fact Table Loader
• Dimension Loader

Orchestration and Automation

• Using Workflows for Orchestration
• Using the Job Scheduler for Automation

Use Case

• Building a Data Warehouse – A Step-By-Step Approach