Looking for the previous version? View v2024.06 documentation →
Show Mapped Objects on Top in TDR
Overview
This guide walks through the Show Mapped Objects on Top in TDR scenario in Data Trust Scenario Studio. Follow the numbered steps below to configure, execute, and review the results of this scenario type.
Prerequisites
- You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
- The relevant connection profiles have been configured in the Administration module.
Steps
Path: Data Trust › Scenario Studio › Scenario Builder › Show Mapped Objects on Top in TDR
Navigate to the Scenario Studio module and select the Show Mapped Objects on Top in TDR option from the left sidebar or main menu. This opens the scenario builder canvas where you will configure the data source connections, transformation rules, and execution settings.
The Show Mapped Objects on Top in TDR create page is the starting point for building a new scenario. Provide a name for the scenario, choose the appropriate folder, and then proceed to configure data sources and execution logic on the canvas.
Drag the Rdbms Widget from the widget palette and drop it onto the scenario canvas. Positioning the widget opens its configuration popup where you will set the connection, table, and any additional options.
The RDBMS Popup dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.
Select the appropriate connection from the dropdown to link this widget to its data source. Choosing the correct connection profile ensures the scenario reads from or writes to the intended database or file system.
Click the Save button to persist the current widget or scenario configuration. A confirmation indicator appears on the canvas once the save is successful, and the widget thumbnail updates to reflect the configured state.
Drag the Target Rdbms Widget- from the widget palette and drop it onto the scenario canvas. Positioning the widget opens its configuration popup where you will set the connection, table, and any additional options.
Select the appropriate connection from the dropdown to link this widget to its data source. Choosing the correct connection profile ensures the scenario reads from or writes to the intended database or file system.
Click the Save button to persist the current widget or scenario configuration. A confirmation indicator appears on the canvas once the save is successful, and the widget thumbnail updates to reflect the configured state.
Drag the Count Compare Widget from the widget palette and drop it onto the scenario canvas. Positioning the widget opens its configuration popup where you will set the connection, table, and any additional options.
The Count Compare widget popup dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.
Navigate to the Scenario Studio module and select the Show Mapped Objects on Top in TDR option from the left sidebar or main menu. This opens the scenario builder canvas where you will configure the data source connections, transformation rules, and execution settings.
This step involves interacting with the Source Tables within the Show Mapped Objects on Top in TDR workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.
Navigate to the Scenario Studio module and select the Show Mapped Objects on Top in TDR option from the left sidebar or main menu. This opens the scenario builder canvas where you will configure the data source connections, transformation rules, and execution settings.
This step involves interacting with the Target tables within the Show Mapped Objects on Top in TDR workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.
The Reconciliation widget maps source fields to target fields for comparison. Use Smart Mapping to automatically propose column matches, then manually adjust any fields that were incorrectly paired before saving.
The Reconciliation widget maps source fields to target fields for comparison. Use Smart Mapping to automatically propose column matches, then manually adjust any fields that were incorrectly paired before saving.
Navigate to the Scenario Studio module and select the Show Mapped Objects on Top in TDR option from the left sidebar or main menu. This opens the scenario builder canvas where you will configure the data source connections, transformation rules, and execution settings.