Generators
Documentation for all generators
Microsoft Fabric
- Microsoft Fabric - Data Store - 1.8
- Microsoft Fabric - Stage - 1.8
- Microsoft Fabric - Stage JDBC - 1.8
- Microsoft Fabric - Stage Files - 1.8
- Microsoft Fabric - Dimensional - 1.8
- Microsoft Fabric - Dimensional and Mart - 1.8
- Microsoft Fabric - DataVault - 1.8
- Microsoft Fabric - DataVault and Mart - 1.8
- Microsoft Fabric - Datamart - 1.8
- Microsoft Fabric - DataVault - 1.7
- Microsoft Fabric - DataVault and Mart - 1.7
- Microsoft Fabric - Stage JDBC - 1.7
- Microsoft Fabric - Stage Files - 1.7
- Microsoft Fabric - DataVault - 1.6
- Microsoft Fabric - DataVault and Mart - 1.6
- Microsoft Fabric - Stage JDBC - 1.6
- Microsoft Fabric - Stage Files - 1.6
Databricks
- Databricks - Data Store - 1.8
- Databricks - Stage - 1.8
- Databricks - Stage JDBC - 1.8
- Databricks - Stage Files - 1.8
- Databricks - Dimensional - 1.8
- Databricks - Dimensional and Mart - 1.8
- Databricks - DataVault - 1.8
- Databricks - DataVault and Mart - 1.8
- Databricks - Datamart - 1.8
- Databricks - DataVault - 1.7
- Databricks - DataVault and Mart - 1.7
- Databricks - Stage JDBC - 1.7
- Databricks - Stage Files - 1.7
- Databricks - DataVault - 1.6
- Databricks - DataVault and Mart - 1.6
- Databricks - Stage JDBC - 1.6
- Databricks - Stage Files - 1.6
Snowflake
- Snowflake Stage - 1.8
- Snowflake Stage Files - 1.8
- Snowflake Dimensional - 1.8
- Snowflake Dimensional and Mart - 1.8
- Snowflake DataVault - 1.8
- Snowflake DataVault and Mart - 1.8
- Snowflake Datamart - 1.8
- Snowflake - Dimensional - 1.7
- Snowflake - Dimensional and Mart - 1.7
- Snowflake - DataVault - 1.7
- Snowflake - DataVault and Mart - 1.7
- Snowflake - DataVault - 1.6
- Snowflake - DataVault and Mart - 1.6
Microsoft SQL Server
- Microsoft SQL Server - Data Store - 1.8
- Microsoft SQL Server - Stage - 1.8
- Microsoft SQL Server - Stage OpenQuery - 1.8
- Microsoft SQL Server - Stage Files - 1.8
- Microsoft SQL Server - Dimensional - 1.8
- Microsoft SQL Server - Dimensional and Mart - 1.8
- Microsoft SQL Server - DataVault - 1.8
- Microsoft SQL Server - DataVault and Mart - 1.8
- Microsoft SQL Server - Datamart - 1.8
- Microsoft SQL Server - Stage Files - 1.7
- Microsoft SQL Server - Stage OpenQuery - 1.7
- Microsoft SQL Server - Data Store - 1.7
- Microsoft SQL Server - Dimensional - 1.7
- Microsoft SQL Server - Dimensional and Mart - 1.7
- Microsoft SQL Server - DataVault - 1.7
- Microsoft SQL Server - DataVault and Mart - 1.7
- Microsoft SQL Server - Dimensional - 1.6
- Microsoft SQL Server - DataVault - 1.6
- Microsoft SQL Server - DataVault and Mart - 1.6
Artifacts
Replace Placeholders
- Replace the placeholders in the Artifacts
- Microsoft Fabric - Placeholder values - 1.8
- Databricks - Placeholder values - 1.8
- Databricks Unity - Placeholder values - 1.8
- Azure Synapse - Placeholder values - 1.8
- Snowflake - Placeholder values - 1.8
- Microsoft SQL Server - Placeholder values - 1.8
- Microsoft Fabric - Placeholder values - 1.7
- Databricks - Placeholder values - 1.7
- Databricks Unity - Placeholder values - 1.7
- Azure Synapse - Placeholder values - 1.7
- Azure Synapse Stage JDBC - Replace placeholders - 1.7
- Azure Synapse Stage Files - Replace placeholders - 1.7
- Snowflake - Placeholder values - 1.7
- Microsoft SQL Server - Placeholder values - 1.7
- Microsoft SQL Server Stage Files - Replace placeholders - 1.7
- Microsoft SQL Server Stage OpenQuery - Replace placeholders - 1.7
- Microsoft Fabric - Replace the placeholders - 1.6
- Microsoft Fabric Stage JDBC - Replace the placeholders - 1.6
- Microsoft Fabric Stage Files - Replace the placeholders - 1.6
- Databricks - Replace the placeholders - 1.6
- Databricks Stage JDBC - Replace the placeholders - 1.6
- Databricks Stage Files - Replace the placeholders - 1.6
- Azure Synapse - Replace the placeholders - 1.6
- Azure Synapse Stage JDBC - Replace the placeholders - 1.6
- Azure Synapse Stage Files - Replace the placeholders - 1.6
- Snowflake - Replace the placeholders - 1.6
- Microsoft SQL Server - Replace the placeholders - 1.6
Target solution environment
- Microsoft Fabric - Target environment
- Databricks - Target environment
- Databricks Unity - Target environment
- Azure Synapse - Target environment
- Snowflake - Target environment
- Microsoft SQL Server - Target environment
Deployment
- Microsoft Fabric - Deployment - 1.8
- Databricks - Deployment - 1.8
- Databricks Unity - Deployment - 1.8
- Azure Synapse - Deployment - 1.8
- Snowflake - Deployment - 1.8
- Microsoft SQL Server - Deployment - 1.8
- Microsoft Fabric - Deployment - 1.7
- Databricks - Deployment - 1.7
- Databricks Unity - Deployment - 1.7
- Azure Synapse - Deployment - 1.7
- Snowflake - Deployment - 1.7
- Microsoft SQL Server - Deployment - 1.7
- Microsoft Fabric - Deployment - 1.6
- Databricks - Deployment - 1.6
- Azure Synapse - Deployment - 1.6
- Snowflake - Deployment - 1.6
- Microsoft SQL Server - Deployment - 1.6
Load control environment
- Understand Load Control
- Configure Load Control
- Plan Load Control
- Execute Load Control
- Monitor Load Control
- Native - Load control environment
- Apache Airflow - Load control environment
Load data with a native load control
- Databricks - Load data - Native Load Control - 1.8
- Microsoft Fabric - Load data - Native Load Control - 1.8
- Databricks Unity - Load data - Native Load Control - 1.8
- Azure Synapse - Load data - Native Load Control - 1.8
- Snowflake - Load data - Native Load Control - 1.8
- Microsoft SQL Server - Load data - Native Load Control - 1.8
- Microsoft Fabric - Load data - Native Load Control - 1.7
- Databricks - Load data - Native Load Control - 1.7
- Databricks Unity - Load data - Native Load Control - 1.7
- Azure Synapse - Load data - Native Load Control - 1.7
- Snowflake - Load data - Native Load Control - 1.7
- Microsoft SQL Server - Load data - Native Load Control - 1.7
- Microsoft Fabric - Load data - Native Load Control - 1.6
- Databricks - Load data - Native Load Control - 1.6
- Azure Synapse - Load data - Native Load Control - 1.6
- Snowflake - Load data - Native Load Control - 1.6
- Microsoft SQL Server - Load data - Native Load Control - 1.6
Load data with Apache Airflow
- Databricks - Load data - Apache Airflow Load Control - 1.8
- Snowflake - Load data - Apache Airflow Load Control - 1.8
- Microsoft SQL Server - Load data - Apache Airflow Load Control - 1.8
- Databricks - Load data - Apache Airflow Load Control - 1.7
- Snowflake - Load data - Apache Airflow Load Control - 1.7
- Microsoft SQL Server - Load data - Apache Airflow Load Control - 1.7
- Microsoft SQL Server - Load data - Apache Airflow Load Control - 1.6
- Databricks - Load data - Apache Airflow Load Control - 1.6
Model Object Type
- Create a Source
- Create a Stage
- Create a Core Composite
- Create an Entity
- Create a Fact
- Create a Raw Vault Composite
- Create a Hub
- Create a Satellite
- Create a Link
- Create a Link Satellite
- Create a Multi-Active Satellite
- Create a Same as Link
- Create a Hierarchical Link
- Create an Effectivity Satellite
- Create a Record Tracking Satellite
- Create an Effectivity Link Satellite
- Create a Record Tracking Link Satellite
- Create a Non-Historized Link Satellite
- Create a PIT
- Create a Reference Table
- Create a Driving Key Link
- Create a Current View
- Create a History View
- Create a Business Vault Composite
- Create a Business Hub
- Create a Business Satellite
- Create a Business Link
- Create a Business Link Satellite
- Create a Same as Business Link
- Create a Hierarchical Business Link
- Create an Effectivity Business Satellite
- Create a Record Tracking Business Link Satellite
- Create an Effectivity Business Link Satellite
- Create a Non-Historized Business Link Satellite
- Create a Business PIT
- Create a Mart Composite
- Create a Mart Dimension
- Create a Business Current View
- Create a Business History View
- Create a Mart Fact
- Create a Store Composite
- Create a Store Entity
Properties
- Begin of Universe (Project)
- End of Universe (Project)
- Unity Catalog (Project)
- Target Platform (Project)
- Configure LoadControl (Project)
- Deploy LoadControl (Project)
- LoadControl Options (Project)
- Hash Algorithm (Project)
- Implementation Type (Model Object)
- Load Caching (Model Object)
- File Format (Model Object)
- Optimization Method (Model Object)
- Optimization Method Columns (Model Object)
- Use Stream (Model Object)
- Delete Detection Method (Model Object)
- Delete Detection Source (Model Object)
- File Extension (Model Object)
- File Group Pattern (Model Object)
- Column Collation (Model Object)
- Column Delimiter (Model Object)
- Row Delimiter (Model Object)
- Batch Size (Model Object)
- Code Page (Model Object)
- Field Quote (Model Object)
- First Data Row (Model Object)
- Historization Type (Term and Relationship)
- Deduplication Method (Dataflow)
- Deduplication Partition (Dataflow)
- Fact Load Strategy (Dataflow)
- ValidFrom Source Term (Dataflow Model Object)
- Driving Key (Relationship)
- Partition Filter (Target Term)
- Native Data Type (Term Mapping)
Default Terms
- Hub_HK
- Pit_HK
- Link_HK
- DrivingKeyLink_HK
- BG_LoadTimestamp
- BG_SourceSystem
- BG_ValidFromTimestamp
- BG_ValidToTimestamp
- BG_RowHash
- BG_Sequence
- BG_Effectivity_Begin
- BG_Effectivity_End
- BG_Appearance
- BG_IncrementalFilter
- BG_DataflowName
- BG_DataflowSetName
- BG_ID
- BG_SourceFilePath
- BG_UpdateTimestamp
- BG_ErrorCount
- BG_ErrorDescription
- BG_EffectiveTimestamp
- BG_Cleanse_ID
- BG_IsDeleted
- BG_RowHashScd1
- BG_RowHashScd2