---
title: "VaultSpeed Loading Logic"
canonical: "https://docs.vaultspeed.com/space/VPD/3013804066/VaultSpeed%20Loading%20Logic"
format: markdown
---
> Macro (toc)

This article shows you the default implementation flow used by VaultSpeed to load data from source systems to the Data Vault.

In the subpages, you can see different specific loading logics as used by VaultSpeed.

> Macro (children)

# General Flow

Below is the general flow on how the data is loaded from the source to the data vault.


> Macro (drawio)


# Schema Definitions

VaultSpeed uses several different schemas for the different layers.  Here is a list of all schemas that you can have during the load

| **SCHEMA_CODE** | **Description** | **SRC SPECIFIC** | **LOCATION** | **Comments** |
| --- | --- | --- | --- | --- |
| **remote CDC systems** |  |  |  |  |
| SCHEMA_CDCR | The name of the schema for the incremental load tables on the source. | Y | Remote Side | Only used with REMOTE_JOURNALING_TABLES = Y |
| SCHEMA_INI_R | The name of the schema for the initial load tables on the source. | Y | Remote Side | Only used with REMOTE_JOURNALING_TABLES = Y |
| SCHEMA_DTVR | The name of the remote schema for the Delta Layer views which will filter the records for this specific load. | Y | Remote Side | Only used with REMOTE_JOURNALING_TABLES = Y and CREATE_REMOTE_DELTA_VIEWS = Y |
| SCHEMA_MTDR | The name of the remote schema for the metadata tables, in this case the table with the loading frame window. | Y | Remote Side | Only used with REMOTE_JOURNALING_TABLES = Y and CREATE_REMOTE_DELTA_VIEWS = Y |
| SCHEMA_DTV | The name of the schema for the Delta Layer. This will be a copy of the data of the delta view on the remote side | Y | Target Side | Only used with REMOTE_JOURNALING_TABLES = Y |
|  |  |  |  |  |
| **Initial flow** |  |  |  |  |
| SCHEMA_INI | The name of the schema for the initial load tables. | Y | Target Side |  |
|  |  |  |  |  |
| **Incremental flow** |  |  |  |  |
| SCHEMA_CDC | The name of the schema for the incremental load tables. | Y | Target Side |  |
| SCHEMA_DFV | The name of the schema for the Delta Firewall Layer. (Filter time window) | Y | Target Side |  |
| SCHEMA_EXT | The name of the schema for the Extraction tables (Prepare the business keys, data quality bad checks) and the | Y | Target Side |  |
| SCHEMA_STG | The name of the schema for the Staging tables (Lookups, Calculate Hash keys, …) | Y | Target Side |  |
| SCHEMA_FL | The name of the schema for the Raw Data Vault tables. | N | Target Side |  |
| SCHEMA_BV | The name of the schema for the Business Vault tables. | N | Target Side |  |
| SCHEMA_FMC | The name of the schema for the Flow Management Control layer. | N | Target Side |  |
| SCHEMA_MTD | The name of the schema for the metadata tables. (Tables regarding load_cycle_id, delta windows) | Y | Target Side |  |
|  |  |  |  |  |
| **Loading logic** |  |  |  |  |
| SCHEMA_PROCEDURES | The name of the schema for where all the procedures will be deployed. (All the generated ETL/ELT code will be deployed here) | N | Target Side |  |