Autoplay
Autocomplete
Previous
Next
TimeXtender Classic - Optimization
Getting Started
What to Expect: Course Overview
Developer Tools
Quick Start: Project Perspectives
Exercise: Create Perspective
Quick Start: System Control Fields
Quick Start: SQL Database Cleanup Tool
Quick Start: Table Performance Settings
Quick Start: Index Automation
Quiz: Developer Tools
Schemas, Views and Simple Mode
Quick Start: Schemas
Exercise: Create Schema and assign Behavior
Quick Start: Views
Exercise: Create, Edit and Synchronize View
Quick Start: Simple Mode
Exercise: Enable Simple Mode
Quiz: Views and Simple Mode
Data Quality
Quick Start: Primary Key Behavior
Quick Start: Relationship Types
Exercise: Referential Integrity
Quick Start: Handling Nulls
Quick Start: Validation Rules
Exercise: Create Data Validation rule
Quick Start: Warnings and Errors
Quiz: Data Quality
Surrogate Keys and History
Quick Start: Supernatural Keys
Exercise: Add Supernatural Key
Quick Start: History
Exercise: Enable History Type I for Customer table
Quiz: Surrogate Keys and History
Incremental Load
Overview: Incremental Load
Quick Start: Incremental Load in ODX Server
Exercise: Incremental Load in ODX
Quick Start: Incremental Loading in Data Warehouses
Quiz: Incremental Load
Compliance
Quick Start: Data Lineage
Quick Start: Documentation
Quiz: Compliance
Execution
Quick Start: Execution Packages
Quick Start: Schedules
Exercise: Add and Schedule Execution Package for Sales
Quick Start: Execution History
Quick Start: Execution Queue
Quiz: Execution
Next Steps
Quick Start (optional): Using Azure SQL DB Serverless
TimeXtender Tuesday
Next Steps
Feedback
Exercise: Create Schema and assign Behavior
In the
MDW
right click
Database Schemas
node and choose
Add Database Schema
Type
dbo
in the
Name
box and click
OK
Create schema
ETL
the same way
Expand the
Database Schemas
node, right click
ETL
schema and choose
Schema Behavior -> Main default schema
Right click
dbo
schema and choose
Schema Behavior -> Main Valid default schema
Right click
MDW
node, choose
Deploy and Execute
and remove the tick at
Enable
differential deployment
(To make sure all objects in
MDW
are included)
click
Start
and
Save
Show Example
Note: Video is free of audio
Next