The tutorials in the Advanced Course build on the Intro Course. The starting point and state of the contents in the DemoDW database is the end of Tutorial 10 of the Intro Course. By this time you are familiar with the overall development process, so the most basic information will not be covered here.
For reference, have a look at the links on the Intro Course front page.
Tutorial List
| Tutorial | What We Learn |
|---|---|
| 01. Key Groups | Separate collision-prone and logically incompatible business keys by using Key Groups. |
| 02. Implementing the Participation Design Pattern | Implement straight references in the source data using the more flexible Participation design pattern instead. |
| 03. Versioned Source Data | Implement a loading mechanism that only loads the latest version of the data from a set containing multiple versions. We also see how we can batch load the older versions in one go. |
| 04. Advanced State Handling | Fine-tune how individual rows are marked as deleted (D) when state handling is turned on for a class, even for incremental loads. |
| 05. Simple Hierarchy | Split hierarchical data in different ways. |
| 06. Hierarchy Depth Changes | What kind of changes are required when a flat hierarchy gets a new level. |
| 07. Partial Load Deletion Detection | Automatically apply a source-aware algorithm for deletion detection to mark data as deleted. |
| 08. Merge Hashes Non-Destructively | Substitute a specific hash value for another in order to combine and standardize the way data is shown and used. |
| 09: Implementing Business Objects | We learn the basics of how to create mappings between classes. |
| 10. Custom Value Transformations | We will be dipping our toes in C# programming, creating custom transformations to be used in conjunction with source mappings. |
