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
  • »
  • Search

© Copyright 2019, Astera Software