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
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
Foundation: Incremental Loading
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 Perspective
Create dynamic perspectives Product and Sales
Right click the
Project Perspectives
node in the
Solution Explorer
and choose
Add/Edit Project Perspective
Click the
Add
button and replace the text
Perspective
on top of the new column with
Product
Expand the
Tables
node beneath
MDW
and set a tick in the box next to the
Product
table
Set a tick next to
Dynamic Perspective
in the
Product
column
Click the
Add
button and replace the text
Perspective
on top of the new column with
Sales
Expand the
Semantic Models
node and set a tick next to
Sales
Set a tick next to
Dynamic Perspective
in the
Sales
column and click
OK
button.
Show Example
Note: Video is free of audio
Next
Lecture Content Locked
Your session expired. Please sign in again to continue.
Login