---
schema_version: "1"
id: a0492ee25c15f6cfb0cb3fe616c20c46e160a1f10b8f6560ad2a834f0c831aa2
title: Change Granular Data Center Connections
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_data_lakes_visualize_change.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_lakes_visualize_change.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e77b95050410fa8de0fccab861783367a14841533ee774bf4e87d3dd1ad396ce
description: You can change the joins created between dimensions and tables by modifying the ERD. Connect relevant fields in just a few clicks, while defining the join type, and the cardinality type.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Change Granular Data Center Connections

You can change the joins created between dimensions and tables by modifying the ERD. Connect relevant fields in just a few clicks, while defining the join type, and the cardinality type.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d30278e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d30278e38 ">To change Granular Data Center connections:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d30278e38 ">Admin</td>

          </tr>
        </tbody>
      </table>

1. From the **Connect & Mix** tab, select **Granular Data Center**, and then **Granular Data ERD**.
2. Use your mouse to zoom in or out and to move the diagram to the left or right.
    
    You can also use the map at the bottom left-hand side of the page to move to the desired location.
3. A line connecting tables indicates a relationship between specific dimensions, this connection is called a fusion.
    
    ![new\_erd](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/datalakes/data_lake_erd_new.png)
4. To create a connection between tables, click an entity and drag until you reach the entity you’re connecting to. As you’re dragging, a line appears.
5. After a connection is made, click **Join Type** to determine when and how records are returned for the joined entities.
    
    ![join\_type](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/datalakes/data_lake_join.png)
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><tbody><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Inner</strong></td><td class="slds-cell-wrap">Returns common records from both tables.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Left</strong></td><td class="slds-cell-wrap">Returns all records from the left table and any matches from the right table.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Full</strong></td><td class="slds-cell-wrap">Returns all records even if no matches are found from the left or right table.</td></tr></tbody></table>
6. To define the type of relationship, from the **Select Cardinality** dropdown select one of the following: One to many, Many to one, or Many to many.
7. Save your changes.