biGENIUS-X Knowledge Base

Back to home

biGENIUS-X Knowledge Base

Generators

Generators

Documentation for all generators

Available Generator Configurations

Use a biGENIUS-X Generator

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

See more

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

See more

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

See more

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

See more

Artifacts

Microsoft Fabric - Artifacts - 1.8

Databricks - Artifacts - 1.8

Snowflake - Artifacts - 1.8

Microsoft SQL Server - Artifacts - 1.8

Microsoft Fabric - Artifacts - 1.7

Databricks - Artifacts - 1.7

Snowflake - Artifacts - 1.7

Microsoft SQL Server - Artifacts - 1.7

Microsoft Fabric - Artifacts - 1.6

Databricks - Artifacts - 1.6

Snowflake - Artifacts - 1.6

Microsoft SQL Server - Artifacts - 1.6

See more

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

Snowflake - Placeholder values - 1.7

Microsoft SQL Server - Placeholder values - 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

Databricks - Target environment

Databricks Unity - Target environment

Azure Synapse - Target environment

Snowflake - Target environment

Microsoft SQL Server - Target environment

See more

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

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

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

See more

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

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 (Target 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