--- title: Generators | biGENIUS-X Knowledge Base description: Documentation for all generators --- [Skip to content](https://knowledge.bigenius-x.com/generators#main-content) [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal) [![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/) Open main navigation Close main navigation - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new) - [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal) How can we help you? - There are no suggestions because the search field is empty. 1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/) 2. [Generators](https://knowledge.bigenius-x.com/generators) # Generators Documentation for all generators - [Use a biGENIUS-X Generator](https://knowledge.bigenius-x.com/use-a-bigenius-x-generator) - [Available Generator Configurations](https://knowledge.bigenius-x.com/available-generator-configurations) - [Source systems per generator configuration](https://knowledge.bigenius-x.com/source-systems-per-generator-configuration) ## Databricks - [Databricks Stage](https://knowledge.bigenius-x.com/databricks-stage) - [Databricks Stage Files](https://knowledge.bigenius-x.com/databricks-stage-files) - [Databricks Stage JDBC](https://knowledge.bigenius-x.com/databricks-stage-jdbc) - [Databricks Data Store](https://knowledge.bigenius-x.com/databricks-data-store) - [Databricks Dimensional](https://knowledge.bigenius-x.com/databricks-dimensional) - [Databricks Dimensional and Mart](https://knowledge.bigenius-x.com/databricks-dimensional-and-mart) - [Databricks Data Vault](https://knowledge.bigenius-x.com/databricks-data-vault) - [Databricks Data Vault and Mart](https://knowledge.bigenius-x.com/databricks-data-vault-and-mart) - [Databricks Data Mart](https://knowledge.bigenius-x.com/databricks-data-mart) See less ▼ ## Databricks dbt - [Databricks dbt Data Vault](https://knowledge.bigenius-x.com/databricks-dbt-data-vault) - [Databricks dbt Data Vault and Mart](https://knowledge.bigenius-x.com/databricks-dbt-data-vault-and-mart) - [Databricks dbt Data Mart](https://knowledge.bigenius-x.com/databricks-dbt-data-mart) ## Fabric Lakehouse - [Fabric Lakehouse Stage](https://knowledge.bigenius-x.com/fabric-lakehouse-stage) - [Fabric Lakehouse Stage Files](https://knowledge.bigenius-x.com/fabric-lakehouse-stage-files) - [Fabric Lakehouse Stage JDBC](https://knowledge.bigenius-x.com/fabric-lakehouse-stage-jdbc) - [Fabric Lakehouse Data Store](https://knowledge.bigenius-x.com/fabric-lakehouse-data-store) - [Fabric Lakehouse Dimensional](https://knowledge.bigenius-x.com/fabric-lakehouse-dimensional) - [Fabric Lakehouse Dimensional and Mart](https://knowledge.bigenius-x.com/fabric-lakehouse-dimensional-and-mart) - [Fabric Lakehouse Data Vault](https://knowledge.bigenius-x.com/fabric-lakehouse-data-vault) - [Fabric Lakehouse Data Vault and Mart](https://knowledge.bigenius-x.com/fabric-lakehouse-data-vault-and-mart) - [Fabric Lakehouse Data Mart](https://knowledge.bigenius-x.com/fabric-lakehouse-data-mart) See less ▼ ## Fabric Warehouse - [Fabric Warehouse Stage](https://knowledge.bigenius-x.com/fabric-warehouse-stage) - [Fabric Warehouse Data Store](https://knowledge.bigenius-x.com/fabric-warehouse-data-store) - [Fabric Warehouse Dimensional](https://knowledge.bigenius-x.com/fabric-warehouse-dimensional) - [Fabric Warehouse Dimensional and Mart](https://knowledge.bigenius-x.com/fabric-warehouse-dimensional-and-mart) - [Fabric Warehouse Data Vault](https://knowledge.bigenius-x.com/fabric-warehouse-data-vault) - [Fabric Warehouse Data Vault and Mart](https://knowledge.bigenius-x.com/fabric-warehouse-data-vault-and-mart) - [Fabric Warehouse Data Mart](https://knowledge.bigenius-x.com/fabric-warehouse-data-mart) See less ▼ ## Microsoft SQL Server - [Microsoft SQL Server Stage](https://knowledge.bigenius-x.com/microsoft-sql-server-stage) - [Microsoft SQL Server Stage Files](https://knowledge.bigenius-x.com/microsoft-sql-server-stage-files) - [Microsoft SQL Server Stage OpenQuery](https://knowledge.bigenius-x.com/microsoft-sql-server-stage-openquery) - [Microsoft SQL Server Data Store](https://knowledge.bigenius-x.com/microsoft-sql-server-data-store) - [Microsoft SQL Server Dimensional](https://knowledge.bigenius-x.com/microsoft-sql-server-dimensional) - [Microsoft SQL Server Dimensional and Mart](https://knowledge.bigenius-x.com/microsoft-sql-server-dimensional-and-mart) - [Microsoft SQL Server Data Vault](https://knowledge.bigenius-x.com/microsoft-sql-server-data-vault) - [Microsoft SQL Server Data Vault and Mart](https://knowledge.bigenius-x.com/microsoft-sql-server-data-vault-and-mart) - [Microsoft SQL Server Data Mart](https://knowledge.bigenius-x.com/microsoft-sql-server-data-mart) See less ▼ ## Oracle - [Oracle Stage](https://knowledge.bigenius-x.com/oracle-stage) - [Oracle Data Store](https://knowledge.bigenius-x.com/oracle-data-store) - [Oracle Data Vault](https://knowledge.bigenius-x.com/oracle-data-vault) - [Oracle Data Vault and Mart](https://knowledge.bigenius-x.com/oracle-data-vault-and-mart) - [Oracle Data Mart](https://knowledge.bigenius-x.com/oracle-data-mart) ## Snowflake - [Snowflake Stage](https://knowledge.bigenius-x.com/snowflake-stage) - [Snowflake Stage Files](https://knowledge.bigenius-x.com/snowflake-stage-files) - [Snowflake Data Store](https://knowledge.bigenius-x.com/snowflake-data-store) - [Snowflake Dimensional](https://knowledge.bigenius-x.com/snowflake-dimensional) - [Snowflake Dimensional and Mart](https://knowledge.bigenius-x.com/snowflake-dimensional-and-mart) - [Snowflake Data Vault](https://knowledge.bigenius-x.com/snowflake-data-vault) - [Snowflake Data Vault and Mart](https://knowledge.bigenius-x.com/snowflake-data-vault-and-mart) - [Snowflake Data Mart](https://knowledge.bigenius-x.com/snowflake-data-mart) See less ▼ ## Snowflake dbt - [Snowflake dbt Data Vault](https://knowledge.bigenius-x.com/snowflake-dbt-data-vault) ## Artifacts - [Databricks - Artifacts](https://knowledge.bigenius-x.com/databricks-artifacts) - [Fabric Lakehouse - Artifacts](https://knowledge.bigenius-x.com/fabric-lakehouse-artifacts) - [Fabric Warehouse - Artifacts](https://knowledge.bigenius-x.com/fabric-warehouse-artifacts) - [Microsoft SQL Server - Artifacts](https://knowledge.bigenius-x.com/microsoft-sql-server-artifacts) - [Oracle - Artifacts](https://knowledge.bigenius-x.com/oracle-artifacts) - [Snowflake - Artifacts](https://knowledge.bigenius-x.com/snowflake-artifacts) - [dbt - Artifacts](https://knowledge.bigenius-x.com/dbt-artifacts) - [Troubleshoot generation, deployment and load failures](https://knowledge.bigenius-x.com/troubleshoot-generation-deployment-and-load-failures) See less ▼ ## Replace Placeholders - [Replace the placeholders in the artifacts](https://knowledge.bigenius-x.com/replace-the-placeholders-in-the-artifacts) - [Databricks - Placeholder values](https://knowledge.bigenius-x.com/databricks-placeholder-values) - [Fabric Lakehouse - Placeholder values](https://knowledge.bigenius-x.com/fabric-lakehouse-placeholder-values) - [Fabric Warehouse - Placeholder values](https://knowledge.bigenius-x.com/fabric-warehouse-placeholder-values) - [Microsoft SQL Server - Placeholder values](https://knowledge.bigenius-x.com/microsoft-sql-server-placeholder-values) - [Oracle - Placeholder values](https://knowledge.bigenius-x.com/oracle-placeholder-values) - [Snowflake - Placeholder values](https://knowledge.bigenius-x.com/snowflake-placeholder-values) - [dbt - Placeholder values](https://knowledge.bigenius-x.com/dbt-placeholder-values) See less ▼ ## Target solution environment - [Azure Synapse - Target environment](https://knowledge.bigenius-x.com/azure-synapse-target-environment) - [Databricks - Target environment with the Hive metastore](https://knowledge.bigenius-x.com/databricks-target-environment-with-the-hive-metastore) - [Databricks - Target environment with Unity Catalog](https://knowledge.bigenius-x.com/databricks-target-environment-with-unity-catalog) - [Databricks dbt - Target environment](https://knowledge.bigenius-x.com/databricks-dbt-target-environment) - [Fabric Lakehouse - Target environment](https://knowledge.bigenius-x.com/fabric-lakehouse-target-environment) - [Fabric Warehouse - Target environment](https://knowledge.bigenius-x.com/fabric-warehouse-target-environment) - [Microsoft SQL Server - Target environment](https://knowledge.bigenius-x.com/microsoft-sql-server-target-environment) - [Oracle - Target environment](https://knowledge.bigenius-x.com/oracle-target-environment) - [Snowflake - Target environment](https://knowledge.bigenius-x.com/snowflake-target-environment) - [Snowflake dbt - Target environment](https://knowledge.bigenius-x.com/snowflake-dbt-target-environment) See less ▼ ## Deployment - [Azure Synapse - Deployment](https://knowledge.bigenius-x.com/azure-synapse-deployment) - [Databricks - Deployment](https://knowledge.bigenius-x.com/databricks-deployment) - [Fabric Lakehouse - Deployment](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment) - [Fabric Warehouse - Deployment](https://knowledge.bigenius-x.com/fabric-warehouse-deployment) - [Microsoft SQL Server - Deployment](https://knowledge.bigenius-x.com/microsoft-sql-server-deployment) - [Oracle - Deployment](https://knowledge.bigenius-x.com/oracle-deployment) - [Snowflake - Deployment](https://knowledge.bigenius-x.com/snowflake-deployment) - [dbt - Deployment](https://knowledge.bigenius-x.com/dbt-deployment) See less ▼ ## Deployment with an Azure DevOps pipeline - [Snowflake - Deployment with an Azure Pipeline](https://knowledge.bigenius-x.com/snowflake-deployment-with-an-azure-pipeline) ## Delta Deployment - [Databricks - Delta Deployment with Liquibase](https://knowledge.bigenius-x.com/databricks-delta-deployment-with-liquibase) - [Microsoft SQL Server - Delta Deployment with Liquibase](https://knowledge.bigenius-x.com/microsoft-sql-server-delta-deployment-with-liquibase) - [Snowflake - Delta Deployment with Liquibase](https://knowledge.bigenius-x.com/snowflake-delta-deployment-with-liquibase) ## Load control environment - [Understand Load Control](https://knowledge.bigenius-x.com/understand-load-control) - [Configure Load Control](https://knowledge.bigenius-x.com/configure-load-control) - [Plan Load Control](https://knowledge.bigenius-x.com/plan-load-control) - [Execute Load Control](https://knowledge.bigenius-x.com/execute-load-control) - [Monitor Load Control](https://knowledge.bigenius-x.com/monitor-load-control) - [Apache Airflow - Load control environment](https://knowledge.bigenius-x.com/apache-airflow-load-control-environment) - [Native - Load control environment](https://knowledge.bigenius-x.com/native-load-control-environment) See less ▼ ## Load data with a native load control - [Azure Synapse - Load data - Native Load Control](https://knowledge.bigenius-x.com/azure-synapse-load-data-native-load-control) - [Databricks - Load data - Native Load Control](https://knowledge.bigenius-x.com/databricks-load-data-native-load-control) - [Fabric Lakehouse - Load data - Native Load Control](https://knowledge.bigenius-x.com/fabric-lakehouse-load-data-native-load-control) - [Fabric Warehouse - Load data - Native Load Control](https://knowledge.bigenius-x.com/fabric-warehouse-load-data-native-load-control) - [Microsoft SQL Server - Load data - Native Load Control](https://knowledge.bigenius-x.com/microsoft-sql-server-load-data-native-load-control) - [Oracle - Load data - Native Load Control](https://knowledge.bigenius-x.com/oracle-load-data-native-load-control) - [Snowflake - Load data - Linked projects](https://knowledge.bigenius-x.com/snowflake-load-data-linked-projects) - [Snowflake - Load data - Native Load Control](https://knowledge.bigenius-x.com/snowflake-load-data-native-load-control) See less ▼ ## Load data with Apache Airflow - [Databricks - Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/databricks-load-data-apache-airflow-load-control) - [Fabric Lakehouse - Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/fabric-lakehouse-load-data-apache-airflow-load-control) - [Microsoft SQL Server - Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/microsoft-sql-server-load-data-apache-airflow-load-control) - [Oracle - Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/oracle-load-data-apache-airflow-load-control) - [Snowflake - Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/snowflake-load-data-apache-airflow-load-control) ## Model Object Type - [Source](https://knowledge.bigenius-x.com/source) - [Stage](https://knowledge.bigenius-x.com/stage) - [Store Composite](https://knowledge.bigenius-x.com/store-composite) - [Store Entity](https://knowledge.bigenius-x.com/store-entity) - [Core Composite](https://knowledge.bigenius-x.com/core-composite) - [Entity](https://knowledge.bigenius-x.com/entity) - [Fact](https://knowledge.bigenius-x.com/fact) - [Current View](https://knowledge.bigenius-x.com/current-view) - [Driving Key Link](https://knowledge.bigenius-x.com/driving-key-link) - [Effectivity Link Satellite](https://knowledge.bigenius-x.com/effectivity-link-satellite) - [Effectivity Satellite](https://knowledge.bigenius-x.com/effectivity-satellite) - [Hierarchical Link](https://knowledge.bigenius-x.com/hierarchical-link) - [History View](https://knowledge.bigenius-x.com/history-view) - [Hub](https://knowledge.bigenius-x.com/hub) - [Link](https://knowledge.bigenius-x.com/link) - [Link Satellite](https://knowledge.bigenius-x.com/link-satellite) - [Multi-Active Satellite](https://knowledge.bigenius-x.com/multi-active-satellite) - [Non-Historized Link Satellite](https://knowledge.bigenius-x.com/non-historized-link-satellite) - [Non-Historized Satellite](https://knowledge.bigenius-x.com/non-historized-satellite) - [PIT](https://knowledge.bigenius-x.com/pit) - [RawVault Composite](https://knowledge.bigenius-x.com/rawvault-composite) - [Record Tracking Link Satellite](https://knowledge.bigenius-x.com/record-tracking-link-satellite) - [Record Tracking Satellite](https://knowledge.bigenius-x.com/record-tracking-satellite) - [Reference Table](https://knowledge.bigenius-x.com/reference-table) - [Same As Link](https://knowledge.bigenius-x.com/same-as-link) - [Satellite](https://knowledge.bigenius-x.com/satellite) - [Vault Out](https://knowledge.bigenius-x.com/vault-out) - [Business Current View](https://knowledge.bigenius-x.com/business-current-view) - [Business Driving Key Link](https://knowledge.bigenius-x.com/business-driving-key-link) - [Business History View](https://knowledge.bigenius-x.com/business-history-view) - [Business Hub](https://knowledge.bigenius-x.com/business-hub) - [Business Link](https://knowledge.bigenius-x.com/business-link) - [Business Link Satellite](https://knowledge.bigenius-x.com/business-link-satellite) - [Business PIT](https://knowledge.bigenius-x.com/business-pit) - [Business Satellite](https://knowledge.bigenius-x.com/business-satellite) - [BusinessVault Composite](https://knowledge.bigenius-x.com/businessvault-composite) - [Effectivity Business Link Satellite](https://knowledge.bigenius-x.com/effectivity-business-link-satellite) - [Effectivity Business Satellite](https://knowledge.bigenius-x.com/effectivity-business-satellite) - [Hierarchical Business Link](https://knowledge.bigenius-x.com/hierarchical-business-link) - [Hierarchy Flatten](https://knowledge.bigenius-x.com/hierarchy-flatten) - [Non-Historized Business Link Satellite](https://knowledge.bigenius-x.com/non-historized-business-link-satellite) - [Non-Historized Business Satellite](https://knowledge.bigenius-x.com/non-historized-business-satellite) - [Record Tracking Business Link Satellite](https://knowledge.bigenius-x.com/record-tracking-business-link-satellite) - [Same As Business Link](https://knowledge.bigenius-x.com/same-as-business-link) - [Mart Composite](https://knowledge.bigenius-x.com/mart-composite) - [Mart Dimension](https://knowledge.bigenius-x.com/mart-dimension) - [Mart Fact](https://knowledge.bigenius-x.com/mart-fact) - [Mart Hierarchy Flatten](https://knowledge.bigenius-x.com/mart-hierarchy-flatten) - [Mart Out](https://knowledge.bigenius-x.com/mart-out) See less ▼ ## Properties - [How biGENIUS-X builds hash values](https://knowledge.bigenius-x.com/how-bigenius-x-builds-hash-values) - [Change detection and historization](https://knowledge.bigenius-x.com/change-detection-and-historization) - [Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader) - [Apply Sensitivity Level Tags (Project)](https://knowledge.bigenius-x.com/apply-sensitivity-level-tags-project) - [Artifact Output Mode (Project)](https://knowledge.bigenius-x.com/artifact-output-mode-project) - [Begin of Universe (Project)](https://knowledge.bigenius-x.com/begin-of-universe-project) - [Behaviour for Nulled Business Keys in Links (Project)](https://knowledge.bigenius-x.com/behaviour-for-nulled-business-keys-in-links-project) - [Configure LoadControl (Project)](https://knowledge.bigenius-x.com/configure-loadcontrol-project) - [Create GRANTs for Imported Objects (Project)](https://knowledge.bigenius-x.com/create-grants-for-imported-objects-project) - [Create Result Views (Project)](https://knowledge.bigenius-x.com/create-result-views-project) - [Database Links for Source Systems (Project)](https://knowledge.bigenius-x.com/database-links-for-source-systems-project) - [Deploy LoadControl (Project)](https://knowledge.bigenius-x.com/deploy-loadcontrol-project) - [Deployment Options (Project)](https://knowledge.bigenius-x.com/deployment-options-project) - [End of Universe (Project)](https://knowledge.bigenius-x.com/end-of-universe-project) - [Hash Algorithm (Project)](https://knowledge.bigenius-x.com/hash-algorithm-project) - [Hash Casing (Project)](https://knowledge.bigenius-x.com/hash-casing-project) - [Hash Concatenation Separator (Project)](https://knowledge.bigenius-x.com/hash-concatenation-separator-project) - [Hash Null Placeholder (Project)](https://knowledge.bigenius-x.com/hash-null-placeholder-project) - [Hash Trim (Project)](https://knowledge.bigenius-x.com/hash-trim-project) - [LoadControl Options (Project)](https://knowledge.bigenius-x.com/loadcontrol-options-project) - [Logging Method (Project)](https://knowledge.bigenius-x.com/logging-method-project) - [Notebook Deployment Objects Limit (Project)](https://knowledge.bigenius-x.com/notebook-deployment-objects-limit-project) - [Persist Validity (Project)](https://knowledge.bigenius-x.com/persist-validity-project) - [Push view to repo (Project)](https://knowledge.bigenius-x.com/push-view-to-repo-project) - [Sensitivity Level Tag Name (Project)](https://knowledge.bigenius-x.com/sensitivity-level-tag-name-project) - [Target Object Comment Type (Project)](https://knowledge.bigenius-x.com/target-object-comment-type-project) - [Target Platform (Project)](https://knowledge.bigenius-x.com/target-platform-project) - [Use Unique Constraints (Project)](https://knowledge.bigenius-x.com/use-unique-constraints-project) - [Use Unity Catalog (Project)](https://knowledge.bigenius-x.com/use-unity-catalog-project) - [Batch Size (Model Object)](https://knowledge.bigenius-x.com/batch-size-model-object) - [Calculate Effectivity End From Begin (Model Object)](https://knowledge.bigenius-x.com/calculate-effectivity-end-from-begin-model-object) - [Code Page (Model Object)](https://knowledge.bigenius-x.com/code-page-model-object) - [Column Collation (Model Object)](https://knowledge.bigenius-x.com/column-collation-model-object) - [Column Delimiter (Model Object)](https://knowledge.bigenius-x.com/column-delimiter-model-object) - [CSV options (Model Object)](https://knowledge.bigenius-x.com/csv-options-model-object) - [Custom Singleton Values (Model Object)](https://knowledge.bigenius-x.com/custom-singleton-values-model-object) - [Delete Detection Method (Model Object)](https://knowledge.bigenius-x.com/delete-detection-method-model-object) - [Delete Detection Partial Operator (Model Object)](https://knowledge.bigenius-x.com/delete-detection-partial-operator-model-object) - [Delete Detection Partial Terms (Model Object)](https://knowledge.bigenius-x.com/delete-detection-partial-terms-model-object) - [Delete Detection Source (Model Object)](https://knowledge.bigenius-x.com/delete-detection-source-model-object) - [Delta Detection (Model Object)](https://knowledge.bigenius-x.com/delta-detection-model-object) - [Excluded from Delta Detection (Model Object)](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object) - [Field Quote (Model Object)](https://knowledge.bigenius-x.com/field-quote-model-object) - [File Extension (Model Object)](https://knowledge.bigenius-x.com/file-extension-model-object) - [File Format (Model Object)](https://knowledge.bigenius-x.com/file-format-model-object) - [File Group Pattern (Model Object)](https://knowledge.bigenius-x.com/file-group-pattern-model-object) - [File Name Pattern (Model Object)](https://knowledge.bigenius-x.com/file-name-pattern-model-object) - [First Data Row (Model Object)](https://knowledge.bigenius-x.com/first-data-row-model-object) - [Foreign Key Mode (Model Object)](https://knowledge.bigenius-x.com/foreign-key-mode-model-object) - [Hash Group Size (Model Object)](https://knowledge.bigenius-x.com/hash-group-size-model-object) - [Implementation Type (Model Object)](https://knowledge.bigenius-x.com/implementation-type-model-object) - [Increment Management Type (Model Object)](https://knowledge.bigenius-x.com/increment-management-type-model-object) - [Load Caching (Model Object)](https://knowledge.bigenius-x.com/load-caching-model-object) - [Optimization Method (Model Object)](https://knowledge.bigenius-x.com/optimization-method-model-object) - [Optimization Method Columns (Model Object)](https://knowledge.bigenius-x.com/optimization-method-columns-model-object) - [Partition Clause and table storage (Model Object)](https://knowledge.bigenius-x.com/partition-clause-and-table-storage-model-object) - [Row Delimiter (Model Object)](https://knowledge.bigenius-x.com/row-delimiter-model-object) - [Use Sequential Dataflow Execution (Model Object)](https://knowledge.bigenius-x.com/use-sequential-dataflow-execution-model-object) - [Use Stream (Model Object)](https://knowledge.bigenius-x.com/use-stream-model-object) - [Ignore Downstream Dependencies (Dataflow Model Object)](https://knowledge.bigenius-x.com/ignore-downstream-dependencies-dataflow-model-object) - [Version Valid From Term (Dataflow Model Object)](https://knowledge.bigenius-x.com/version-valid-from-term-dataflow-model-object) - [Deduplication Method (Dataflow)](https://knowledge.bigenius-x.com/deduplication-method-dataflow) - [Fact Load Strategy (Dataflow)](https://knowledge.bigenius-x.com/fact-load-strategy-dataflow) - [Sort Order within Partition (Dataflow)](https://knowledge.bigenius-x.com/sort-order-within-partition-dataflow) - [Warehouse Placeholder Variable Name (Dataflow)](https://knowledge.bigenius-x.com/warehouse-placeholder-variable-name-dataflow) - [Aggregation Type (Term Mapping)](https://knowledge.bigenius-x.com/aggregation-type-term-mapping) - [Native Data Type (Term Mapping)](https://knowledge.bigenius-x.com/native-data-type-term-mapping) - [Native Expression (Term)](https://knowledge.bigenius-x.com/native-expression-term) - [Partition Filter (Target Term)](https://knowledge.bigenius-x.com/partition-filter-target-term) - [Historization Type (Term and Relationship)](https://knowledge.bigenius-x.com/historization-type-term-and-relationship) - [Driving Key (Relationship)](https://knowledge.bigenius-x.com/driving-key-relationship) - [Index options (Index)](https://knowledge.bigenius-x.com/index-options-index) See less ▼ ## Default Terms - [BG\_Appearance](https://knowledge.bigenius-x.com/bg_appearance) - [BG\_CorruptedRecord](https://knowledge.bigenius-x.com/bg_corruptedrecord) - [BG\_DataflowName](https://knowledge.bigenius-x.com/bg_dataflowname) - [BG\_DataflowSetName](https://knowledge.bigenius-x.com/bg_dataflowsetname) - [BG\_DataQuality\_ID](https://knowledge.bigenius-x.com/bg-dataquality-id) - [BG\_EffectiveTimestamp](https://knowledge.bigenius-x.com/bg_effectivetimestamp) - [BG\_Effectivity\_Begin](https://knowledge.bigenius-x.com/bg-effectivity-begin) - [BG\_Effectivity\_End](https://knowledge.bigenius-x.com/bg_effectivity_end) - [BG\_Entity\_ForeignKey\_Identity](https://knowledge.bigenius-x.com/bg_entity_foreignkey_identity) - [BG\_Entity\_Identity](https://knowledge.bigenius-x.com/bg_entity_identity) - [BG\_ErrorCount](https://knowledge.bigenius-x.com/bg_errorcount) - [BG\_ErrorDescription](https://knowledge.bigenius-x.com/bg_errordescription) - [BG\_Fact\_ForeignKey\_Identity](https://knowledge.bigenius-x.com/bg_fact_foreignkey_identity) - [BG\_ID](https://knowledge.bigenius-x.com/bg_id) - [BG\_IncrementalFilter](https://knowledge.bigenius-x.com/bg_incrementalfilter) - [BG\_IncrementLoadStatus](https://knowledge.bigenius-x.com/bg_incrementloadstatus) - [BG\_IsDeleted](https://knowledge.bigenius-x.com/bg_isdeleted) - [BG\_LoadTimestamp](https://knowledge.bigenius-x.com/bg_loadtimestamp) - [BG\_LowerThreshold](https://knowledge.bigenius-x.com/bg_lowerthreshold) - [BG\_MartDimension\_Identity](https://knowledge.bigenius-x.com/bg_martdimension_identity) - [BG\_MartFact\_ForeignKey\_Identity](https://knowledge.bigenius-x.com/bg_martfact_foreignkey_identity) - [BG\_MAS\_HubDifferenceFound](https://knowledge.bigenius-x.com/bg_mas_hubdifferencefound) - [BG\_RowHash](https://knowledge.bigenius-x.com/bg_rowhash) - [BG\_RowHashScd1](https://knowledge.bigenius-x.com/bg_rowhashscd1) - [BG\_RowHashScd2](https://knowledge.bigenius-x.com/bg_rowhashscd2) - [BG\_Sequence](https://knowledge.bigenius-x.com/bg_sequence) - [BG\_SourceFilePath](https://knowledge.bigenius-x.com/bg_sourcefilepath) - [BG\_SourceSystem](https://knowledge.bigenius-x.com/bg_sourcesystem) - [BG\_UpdateTimestamp](https://knowledge.bigenius-x.com/bg_updatetimestamp) - [BG\_UpperThreshold](https://knowledge.bigenius-x.com/bg_upperthreshold) - [BG\_ValidFromTimestamp](https://knowledge.bigenius-x.com/bg_validfromtimestamp) - [BG\_ValidToTimestamp](https://knowledge.bigenius-x.com/bg_validtotimestamp) - [DrivingKeyLink\_HK](https://knowledge.bigenius-x.com/drivingkeylink_hk) - [DVLINK\_ForeignKey\_Identity](https://knowledge.bigenius-x.com/dvlink_foreignkey_identity) - [DVPIT\_ForeignKey\_Identity](https://knowledge.bigenius-x.com/dvpit_foreignkey_identity) - [DVPIT\_ForeignKey\_LoadDate](https://knowledge.bigenius-x.com/dvpit_foreignkey_loaddate) - [Hub\_HK](https://knowledge.bigenius-x.com/hub_hk) - [Link\_HK](https://knowledge.bigenius-x.com/link_hk) - [PIT\_HK](https://knowledge.bigenius-x.com/pit_hk) See less ▼ - [Getting started](https://knowledge.bigenius-x.com/getting-started#main-content) - [Guidelines](https://knowledge.bigenius-x.com/getting-started#guidelines) - [Start working](https://knowledge.bigenius-x.com/getting-started#start-working) - [Account](https://knowledge.bigenius-x.com/getting-started#account) - [General overview](https://knowledge.bigenius-x.com/general-overview) - [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence) - [Application Modules](https://knowledge.bigenius-x.com/application-modules#main-content) - [Administration](https://knowledge.bigenius-x.com/application-modules#administration) - [Solutions](https://knowledge.bigenius-x.com/application-modules#solutions) - [Global Features](https://knowledge.bigenius-x.com/application-modules#global-features) - [Projects](https://knowledge.bigenius-x.com/application-modules#projects) - [Branches](https://knowledge.bigenius-x.com/application-modules#branches) - [Data Connections](https://knowledge.bigenius-x.com/application-modules#data-connections) - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules#dataflow-modeling-overview) - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules#dataflow-modeling-wizard-steps) - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules#dataflow-modeling-terms) - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules#dataflow-modeling-term-mapping) - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules#dataflow-modeling-relationships) - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules#dataflow-modeling-data-quality) - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules#dataflow-modeling-indexes) - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules#relationship-modeling) - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules#generate-artifacts) - [Project Settings](https://knowledge.bigenius-x.com/application-modules#project-settings) - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules#data-marketplace) - [Generators](https://knowledge.bigenius-x.com/generators#main-content) - [Databricks](https://knowledge.bigenius-x.com/generators#databricks) - [Databricks dbt](https://knowledge.bigenius-x.com/generators#databricks-dbt) - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators#fabric-lakehouse) - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators#fabric-warehouse) - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators#microsoft-sql-server) - [Oracle](https://knowledge.bigenius-x.com/generators#oracle) - [Snowflake](https://knowledge.bigenius-x.com/generators#snowflake) - [Snowflake dbt](https://knowledge.bigenius-x.com/generators#snowflake-dbt) - [Artifacts](https://knowledge.bigenius-x.com/generators#artifacts) - [Replace Placeholders](https://knowledge.bigenius-x.com/generators#replace-placeholders) - [Target solution environment](https://knowledge.bigenius-x.com/generators#target-solution-environment) - [Deployment](https://knowledge.bigenius-x.com/generators#deployment) - [Deployment with an Azure DevOps pipeline](https://knowledge.bigenius-x.com/generators#deployment-with-an-azure-devops-pipeline) - [Delta Deployment](https://knowledge.bigenius-x.com/generators#delta-deployment) - [Load control environment](https://knowledge.bigenius-x.com/generators#load-control-environment) - [Load data with a native load control](https://knowledge.bigenius-x.com/generators#load-data-with-a-native-load-control) - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators#load-data-with-apache-airflow) - [Model Object Type](https://knowledge.bigenius-x.com/generators#model-object-type) - [Properties](https://knowledge.bigenius-x.com/generators#properties) - [Default Terms](https://knowledge.bigenius-x.com/generators#default-terms) - [Discovery application](https://knowledge.bigenius-x.com/discovery-application#main-content) - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application#discovery-configurations) - [Best practices](https://knowledge.bigenius-x.com/best-practices#main-content) - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices#modeling-approaches) - [Use Cases](https://knowledge.bigenius-x.com/best-practices#use-cases) - [Business Rules](https://knowledge.bigenius-x.com/best-practices#business-rules) - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices#data-quality-rules) - [FAQs](https://knowledge.bigenius-x.com/faqs) - [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes#main-content) - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes#saas-application) - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes#discovery-application) - [Generators](https://knowledge.bigenius-x.com/product-release-notes#generators) - [Legal Documents](https://knowledge.bigenius-x.com/legal-documents#main-content) - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents#current-legal-docs) - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents#software-product-and-limits) - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) - [Customer Portal](https://knowledge.bigenius-x.com/customer-portal) - [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login) [![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com) All rights reserved © 2025, biGENIUS AG