Updating the basic information of a foreign key from the Properties view - Cloud - 8.0

Talend Studio User Guide
Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-04-16
Deprecated
Available in...

Data Fabric

MDM Platform

About this task

You can update the foreign key basic information as needed from the Properties view.

Procedure

  1. In the Data Model Entities area, click the foreign key element, and then in the Properties view, click the Relationship tab.
  2. From the Foreign Key tab, you can select:

    • Render in the main tab: to display the foreign key element in the main tab.

    • Enforce FK integrity: to enable foreign key integrity validation, that is, to raise an error whenever a user tries to delete a record if the record is linked to any other records through this foreign key.

    • Allow FK integrity override: to allow users to delete a record even if it is linked to another record through this foreign key.

    For more information about the combined usage of the last two options, see Enabling foreign key integrity checking.