--- title: Create a Term Mapping description: "To create a new Term and its Term Mapping simultaneously in a Model Object, access the Term overview page for a Model Object: Then click on the Plus icon: The Add Term side panel window is opened wi" --- [Skip to content](https://knowledge.bigenius-x.com/create-a-term-mapping#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. [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en) 3. [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping) # Create a Term Mapping ### Create a Term Mapping To create a new Term and its Term Mapping simultaneously in a Model Object, access the [**Term overview**](https://knowledge.bigenius-x.com/understand-terms-overview?hsLang=en) page for a Model Object: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-May-30-2024-09-22-24-2649-AM.png?width=688&height=215&name=image-png-May-30-2024-09-22-24-2649-AM.png) Then click on the **Plus** icon: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-May-30-2024-09-23-12-0343-AM.png?width=688&height=93&name=image-png-May-30-2024-09-23-12-0343-AM.png) The **Add Term** side panel window is opened with the **Term and Term Mapping properties**: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-May-30-2024-09-34-43-9677-AM.png?width=561&height=1029&name=image-png-May-30-2024-09-34-43-9677-AM.png) Fill in the following information: 1. **Name**: Term's name 2. **Description** (*optional*): Term's description 3. **DataType**: The Data Type list depends on the **Semantic** configuration of the **Generator**. In this example, you can choose the following Data Types: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Apr-11-2023-08-47-21-6792-AM.png?width=550&height=220&name=image-png-Apr-11-2023-08-47-21-6792-AM.png) 4. **Length** (*optional*): Term's maximum length. Relevant for a Data Type *varchar,* for example. For Data Type *varchar(50)*, the text can have 50 characters. 5. **Precision** (*optional*): Term's precision. It is the number of digits that make up a number. Relevant for a Data Type *decimal,* for example. For Data Type *decimal(38,17)*, the number can have 38 digits, and 38 - 17 = 21 digits on the left. 6. **Scale** (*optional*): Term's scale. It is the number of digits to the right of the decimal point in a number. Relevant for a Data Type *decimal,* for example. For Data Type *decimal(38,17)*, the number can have 17 digits to the right. 7. **Nullable** (*optional*): Check the box if the Term can be nullable. 8. **Business Key** (*optional*): Check the box if the Term is the Business Key of the Model Object (or a part of the Business Key in case of composed Business Key). 9. **Identity** (*optional*): Check the box if the Term is an Identity.  10. **Hide for mapping source** (*optional*): Check the box if you want to hide the Term in Term Mappings when the Model Object is used as the Source. 1. **Mostly set** to true **by Generator Configuration**. A use case is: the Foreign Key created in a Satellite, when a Relationship to the Hub is made, is checked *Hide for mapping source*. This Term will stay part of the Model Object in the application but will not be part of the result view and table in the generated artifacts. It is only helpful for calculating the correct HK. 11. **Hide for mapping target** (*optional*): Check the box if you want to hide the Term in Term Mappings when the Model Object is used as the Target 12. **Expression**:this is the Term Mapping, which can contain several **Source Terms**: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Apr-25-2023-10-22-06-3700-AM.png?width=610&height=70&name=image-png-Apr-25-2023-10-22-06-3700-AM.png) 13. **Default Value** (o*ptional*): value to apply as Mapping is the Term Mapping is NULL ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-May-30-2024-09-40-20-6748-AM.png?width=688&height=46&name=image-png-May-30-2024-09-40-20-6748-AM.png) 14. **Aggregation Type** (o*ptional*): The Aggregation Type list depends on the **Semantic** configuration of the **Generator**. In this example, you can choose the following Aggregation Types: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-May-30-2024-09-42-10-0106-AM.png?width=465&height=243&name=image-png-May-30-2024-09-42-10-0106-AM.png) Then click on the **Save **button: - The new Term and its term Mappingappears in the **Terms** list of the **Target Model Object**: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-May-30-2024-09-48-25-8077-AM.png?width=826&height=481&name=image-png-May-30-2024-09-48-25-8077-AM.png) - A notification confirms the correct insert: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-May-30-2024-09-47-43-5297-AM.png?width=397&height=67&name=image-png-May-30-2024-09-47-43-5297-AM.png) ### Demonstration video   - [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) All rights reserved © 2025, biGENIUS AG