biGENIUS-X Knowledge Base
Go to bigenius-x.com
Contact us
Go to Customer Portal
Sign in
Generators
Getting Started
Guidelines
Start Working
Connection
General Overview
Application Modules
Administration
Global Features
Solutions
Projects
Branches
Source Systems
Dataflow Modeling - Overview
Dataflow Modeling - Wizard Steps
Dataflow Modeling - Terms
Dataflow Modeling - Term Mapping
Dataflow Modeling - Relationships
Relationship Modeling
Generate Artifacts
Project Settings
Generators
Microsoft Fabric
Databricks
Snowflake
Microsoft SQL Server
Artifacts
Replace Placeholders
Target solution environment
Deployment
Load control environment
Load data with a native load control
Load data with Apache Airflow
Model Object Types
Properties
Default Terms
Discovery application
Discovery configurations
Best Practices
Modeling Approaches
Use Cases
Business Rules
FAQs
Connection
Administration
Projects
Source Systems
Generate Artifacts
Deployment
eLearning
Product Release Notes
SaaS Application
Discovery Application
Generators
Legal Documents
Current legal docs
Software Product and Limits
Back to home
biGENIUS-X Knowledge Base
Generators
Getting Started
Guidelines
Start Working
Connection
General Overview
Application Modules
Administration
Global Features
Solutions
Projects
Branches
Source Systems
Dataflow Modeling - Overview
Dataflow Modeling - Wizard Steps
Dataflow Modeling - Terms
Dataflow Modeling - Term Mapping
Dataflow Modeling - Relationships
Relationship Modeling
Generate Artifacts
Project Settings
Generators
Microsoft Fabric
Databricks
Snowflake
Microsoft SQL Server
Artifacts
Replace Placeholders
Target solution environment
Deployment
Load control environment
Load data with a native load control
Load data with Apache Airflow
Model Object Types
Properties
Default Terms
Discovery application
Discovery configurations
Best Practices
Modeling Approaches
Use Cases
Business Rules
FAQs
Connection
Administration
Projects
Source Systems
Generate Artifacts
Deployment
eLearning
Product Release Notes
SaaS Application
Discovery Application
Generators
Legal Documents
Current legal docs
Software Product and Limits
Generators
Documentation for all generators
Microsoft Fabric
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
See more
Databricks
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
See more
Snowflake
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
See more
Microsoft SQL Server
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
See more
Artifacts
Microsoft Fabric - Artifacts - 1.6
Databricks - Artifacts - 1.6
Snowflake - Artifacts - 1.6
Microsoft SQL Server - Artifacts - 1.6
Microsoft Fabric - Artifacts - 1.7
Databricks - Artifacts - 1.7
Snowflake - Artifacts - 1.7
Microsoft SQL Server - Artifacts - 1.7
See more
Replace Placeholders
Microsoft Fabric - Replace placeholders - 1.7
Microsoft Fabric Stage JDBC - Replace placeholders - 1.7
Microsoft Fabric Stage Files - Replace placeholders - 1.7
Databricks Stage JDBC - Replace placeholders - 1.7
Databricks - Replace placeholders - 1.7
Databricks Stage Files - Replace placeholders - 1.7
Databricks Unity - Replace placeholders - 1.7
Databricks Unity Stage JDBC - Replace placeholders - 1.7
Databricks Unity Stage Files - Replace placeholders - 1.7
Azure Synapse - Replace placeholders - 1.7
Azure Synapse Stage JDBC - Replace placeholders - 1.7
Azure Synapse Stage Files - Replace placeholders - 1.7
Snowflake - Replace placeholders - 1.7
Microsoft SQL Server - Replace placeholders - 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
See more
Target solution environment
Microsoft Fabric - Target environment
Microsoft Fabric Stage JDBC - Target environment
Microsoft Fabric Stage Files - Target environment
Databricks - Target environment
Databricks - Stage JDBC - Target environment
Databricks - Stage Files - Target environment
Databricks Unity - Target environment
Databricks Unity - Stage JDBC - Target environment
Databricks Unity - Stage Files - Target environment
Azure Synapse - Target environment
Azure Synapse - Stage JDBC - Target environment
Azure Synapse - Stage Files - Target environment
Snowflake - Target environment
Microsoft SQL Server - Target environment
Microsoft SQL Server - Stage Files - Target environment
Microsoft SQL Server - Stage OpenQuery - Target environment
See more
Deployment
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
See more
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
See more
Load data with a native load control
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
See more
Load data with Apache Airflow
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
See more
Model Object Types
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
See more
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 (Source Term)
Native Data Type (Term Mapping)
See more
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
See more