Page Index - OptimalBI/optimal-data-engine-mssql GitHub Wiki
62 page(s) in this GitHub Wiki:
- Home
- Data Vault with ODE
- Modelling a Data Vault with ODE
- Configuring with ODE
- Managing the Data Vault with ODE
- Other Cool Features
- Frequently Asked Questions
- ODE Config Structure
- Hubs
- Links
- Satellites
- Delta load
- Release
- Business rules
- Physical tables
- Administration
- Big List of Standards
- Building a Data Vault with ODE v2
- Building a Data Vault with ODE v4
- Calendar or Date Dimension
- Configuration Release Management
- Create a Data Vault with ODE
- Data Vault
- Data Vault naming standards
- How Does ODE Deal with Start End Dating of Satellites
- How To Back Out a Release?
- How To Create a Calculated Field
- How to Create a Hub and Satellite Quickly and Efficiently
- How to Create a Hub and Satellite Quickly and Efficiently with ODE v4
- How to Create a Link and Satellite Quickly and Efficiently
- How to Create Missing Vault Objects
- How To Do a Full Release
- How To Do an Incremental Release
- How To Implement a Link in ODE?
- How To Implement CDC Load for Business Satellite
- How To Implement Delta Load
- How To Implement Delta Load in ODE v4
- How To Implement Same As Link
- How To Monitor and Troubleshoot Data Loads
- How To Reconcile DV Tables Using ODE
- How To Reconcile Tables Using ODE v4
- How To Upgrade ODE
- How To Version Business Rules
- Metrics Vault
- ODE Entity Relationship Diagram
- Persistent Staging Area with ODE
- Preparation for Data Vault Modeling
- Query Builder
- Release Config with SSIS package
- Satellite Change Data Capture Functions
- Should Business Keys be Stored as Concatenated Keys or Separate Fields in the Hub?
- Should the Business Keys be retained on the Satellite?
- SSIS Packages Data Load Type
- Step by Step Configuration of a Data Source and Related Vault Structures
- Task Scheduling
- What are Tombstone Rows and why does ODE have them?
- What Is My Current ODE Version?
- Where do you Store Point in Time for Information for a Link
- Why do Queries, used to load Links often use DISTINCT?
- Why do we Capture all Column Detail in the Configuration Database?
- Why do we Record the Source of each Row in a Satellite?
- Why do we use specify a Unique Row Key on Satellite Tables?