---
title: Plan Load Control
description: "Planning the Load Control means creating execution plans according to the configuration: Each Load Control Configuration can have multiple execution plans. Please find more details about Load Control"
---

[Skip to content](https://knowledge.bigenius-x.com/plan-load-control#main-content)

[Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en)

[![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/?hsLang=en)
2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en)
3. [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment)

# Plan Load Control

### Plan Load Control

Planning the Load Control means creating execution plans according to the configuration:

- Create an execution plan
- Add Loads Objects to the execution Plan

Each Load Control Configuration can have multiple execution plans.

Please find more details about Load Control Configuration here: [Configure Load Control](https://knowledge.bigenius-x.com/configure-load-control?hsLang=en).

It is possible to create different execution plans manually.

The default one(s) generated by biGENIUS-X contains all the Target Objects.

### Example

For example, in a **Microsoft SQL Server Generator with a native Load Control**, the execution plans are stored in the following tables:

![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Aug-01-2024-02-16-19-3439-PM.png?width=323&height=179&name=image-png-Aug-01-2024-02-16-19-3439-PM.png)

- **ExecutionPlan**: the execution plan itself is identified by an ID that will be used in the other tables  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Aug-01-2024-02-23-12-1300-PM.png?width=688&height=59&name=image-png-Aug-01-2024-02-23-12-1300-PM.png)
- **ExecutionPlan\_LoadObject**: the list of executable Target Objects of the execution plan(s)  
  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Aug-01-2024-02-24-16-0394-PM.png?width=688&height=126&name=image-png-Aug-01-2024-02-24-16-0394-PM.png)

#### Create an execution plan

To plan the Load Control, the first step is to create an empty execution plan.

This is done in the *LoadControl\_Execution\_XXXX.sql* script (executed by the helper *execute.ps1*) by the following code:

```
--The execution plan name can be set with any valueEXEC [LC].[Build_ExecutionPlan]                @ExecutionPlan = N'DEV_XXXXX';
```

#### Add Load Objects to the execution plan

To plan the Load Control, the second step is to add Load Objects to the empty execution plan created in the previous step.

Adding all the existing Load Objects is done in the *LoadControl\_Execution\_XXXX.sql* script (executed by the helper *execute.ps1*) by the following code:

```
--The execution plan name must be the same than in the first step--The load config name must be the same as the load configuration created during deployment (Project name)EXEC [LC].[Build_ExecutionPlan_AddLoadObjects] @ExecutionPlan = N'DEV_XXXXX', @LoadConfig = N'XXXXX';
```

But it is also possible to add a subset of Load Objects by using the parameters of the *Build\_ExecutionPlan\_AddLoadObjects* stored procedure:

- **@LoadConfig**: Load Control configuration name. This can be found in the table \[LoadConfig\].\[LoadConfig\]  
    - Example: C3-X-MS-DV
- **@ModelObject**: Model Object name. This can be found in the table \[LoadConfig\_LoadObject\].\[ModelObject\]  
    - Example: PIT\_CreditCard\_Hub

**Dependencies are not included**.

If you precise a specific Model Object, please **add all the Model Objects needed to load the specific Model Object correctly**.  
To **know easily all the Model Objects needed** to correctly load a specific Model Object, including all the dependent objects, you can use the following query: [LoadOnlyOneModelObject\_TSQL.sql](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/LoadOnlyOneModelObject_TSQL.sql).  
Example to add all steps for the load of the PIT table named *PIT\_CreditCard\_Hub*:

- We use the query to have all the dependent object to load this Model Object:

![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Nov-14-2024-09-21-30-2497-AM.png?width=688&height=46&name=image-png-Nov-14-2024-09-21-30-2497-AM.png)

- We build an execution plan with all these objects to be able to load the Model Object *PIT\_CreditCard\_Hub* and all its dependencies:

```
--Create a dedicated execution planEXEC [LC].[Build_ExecutionPlan]  @ExecutionPlan = N'DEV_Load_PIT';--The execution plan name must be the same than in the first step--The load config name must be the same as the load configuration created during deployment (Project name)EXEC [LC].[Build_ExecutionPlan_AddLoadObjects] @ExecutionPlan = N'DEV_Load_PIT', @LoadConfig = N'XXXXX', @ModelObject = N'CreditCard', @ModelObjectLayer=N'Stage';EXEC [LC].[Build_ExecutionPlan_AddLoadObjects] @ExecutionPlan = N'DEV_Load_PIT', @LoadConfig = N'XXXXX', @ModelObject = N'CreditCard_Satellite', @ModelObjectLayer=N'Raw Vault';EXEC [LC].[Build_ExecutionPlan_AddLoadObjects] @ExecutionPlan = N'DEV_Load_PIT', @LoadConfig = N'XXXXX', @ModelObject = N'PIT_CreditCard_Hub', @ModelObjectLayer=N'Raw Vault';
```

- **@ModelObjectPart**: Part of the target data solution. This can be found in the table \[LoadConfig\_LoadObject\].\[ModelObjectPart\]  
    - Example: Hub Loader
- **@ModelObjectDataflow**: Dataflow name. This can be found in the table \[LoadConfig\_LoadObject\].\[ModelObjectDataflow\]. It is mainly used to set loads at different rhythms (daily, weekly...) when defining several Dataflows for a Model Object. See: U[nderstand Dataflow, Dataflow Set, and Dataflow Set Model Object](https://knowledge.bigenius-x.com/understand-dataflow-dataflow-set-and-dataflow-set-model-object?hsLang=en).  
    - Example: Daily
- **@ModelObjectLayer**: Layer containing the Load Objects to load. This can be found in the table \[LoadConfig\_LoadObject\].\[ModelObjectLayer\]  
    - Example: Raw Vault
- **@ModelObjectType**: Model Object Type. This can be found in the table \[LoadConfig\_LoadObject\].\[ModelObjectType\]  
    - Example: Satellite
- **@ErrorBehavior**: Behavior in case of an error during the load of a Load Object. It can be: 
    - *ContinueOnError*: if an error occurs during the load, only the step on error and the dependent steps are in error. All the other steps continue their load.
    - *AbortOnError*: if an error occurs, the load will be stopped at the relevant step.

#### Remove Load Objects from an execution plan

It is possible to remove a subset of Load Objects using the *Build\_ExecutionPlan\_RemoveLoadObjects* stored procedure.

The same parameters as for adding a Load Object can be used.

 

As your Load Control is now planned, you can [execute](https://knowledge.bigenius-x.com/execute-load-control?hsLang=en) it.

 

 

 

- [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content)

    - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines)
    - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working)
    - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account)
- [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en)
- [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en)
- [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content)

    - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration)
    - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions)
    - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features)
    - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects)
    - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches)
    - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections)
    - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview)
    - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps)
    - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms)
    - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping)
    - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships)
    - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality)
    - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes)
    - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling)
    - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts)
    - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings)
    - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace)
- [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content)

    - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse)
    - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse)
    - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks)
    - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake)
    - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server)
    - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts)
    - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders)
    - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment)
    - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment)
    - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline)
    - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment)
    - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment)
    - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control)
    - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow)
    - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type)
    - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties)
    - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms)
- [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content)

    - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations)
- [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content)

    - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches)
    - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases)
    - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules)
    - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules)
- [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en)
- [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content)

    - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application)
    - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application)
    - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators)
- [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content)

    - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs)
    - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#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)

<https://www.linkedin.com/company/bigenius> <https://www.youtube.com/@biGENIUS_DWA>

All rights reserved © 2025, biGENIUS AG