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: Add Supernatural Key
In the
DSA
right click
Product
table and choose
Add Supernatural Key Field
Type
SNK_Product
in the
Name
box
Click the
Add
button next to
Key store
box
In the
Name
box type
Product
Optionally choose a case insensitive
Hashing Algorithm,
if the source database is also case insensitive.
Leave the remaining options at their default values and clisk
OK
button
In the
Business key selection
list click
ProductID
and the
Add
button followed by
OK
button
Notice the new field
SNK_Product
and its datatype.
Show Example
Note: Video is free of audio
Next
Lecture Content Locked
Your session expired. Please sign in again to continue.
Login