Data Warehouse Builder

Home · Centerprise · ReportMiner · EDIConnect · Data Virtualization

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

Data Warehouse Builder

»
Index

Index

© Copyright 2019, Astera Software