Completed
How does it work?
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Temporal Tables and Their Role in ETL and Data Warehouse
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Technical Assistance
- 3 Reza Rad
- 4 Agenda
- 5 Why Temporal Tables?
- 6 What Is Temporal Tables?
- 7 How does it work?
- 8 Temporal Table Definition
- 9 Changes with temporal table
- 10 Querying temporal table
- 11 Slowly Changing Dimension
- 12 Pros and Cons SCD Type 4
- 13 Creating the Table
- 14 Three mandatory columns
- 15 History table name
- 16 SSMS auto generated script
- 17 Create Temporal table from SSMS
- 18 Querying the current data
- 19 Query History Log
- 20 Query All the changes
- 21 Query Data - Methods
- 22 Temporal Tables Pros and Cons
- 23 Incremental Load?
- 24 Rollback
- 25 Considerations
- 26 Temporal Tables Limitations
- 27 Summary
- 28 Study More
