PowerCenter All Products
Reload Tables/Mappings when Opening a Folder
Reloads the last view of a tool when you open it. For example, if you have a mapping open when you disconnect from a repository, the mapping displays the next time you open the folder and the Mapping Designer.
Ask Whether to Reload the Tables/Mappings
Appears only when you select Reload Tables/Mappings when Opening a Folder. Select to have the Designer prompt you to reload objects each time you open a folder.
Display Tool Names on Views
Displays the name of the tool in the upper left corner of the workspace or workbook.
Delay Overview Window Pans
By default, when you drag the focus of the Overview window, the focus of the workbook moves concurrently. When you select this option, the focus of the workspace does not change until you release the mouse button.
Receive Notifications from Repository Service
You can receive notification messages in the Designer and view them in the Output window. Notification messages include information about objects that another user creates, modifies, or deletes. You receive notifications about mappings, mapplets, shortcuts, source definitions, target definitions, and transformations. The Repository Service notifies you of the changes so you know that objects you are working with may be out of date. For the Designer to receive a notification, the folder containing the object must be open in the Navigator. For the Designer to receive notification of a modified or deleted object, the object must be open in the workspace. You also receive user-created notifications that are posted by the user who manages the Repository Service. Default is enabled.
Save All MX Data
Saves all MX data when you save mappings in the Designer. Select this option to use MX views for third-party repository tools.
When you save MX data for mappings, PowerCenter creates a field expression for each target field in the mappings. These expressions are different from the transformation expressions that you create in the Expression Editor.
You must save and check in the mapping before you can access the MX data.
Default is disabled.
Saving MX data can impact repository performance. Use this option only when you want to use MX views.
Save Only Source/Target Dependencies
Saves only dependency-related MX data when you save mappings in the Designer. Select this option if you do not need to view expressions of fields in MX views, but you use the Repository Manager to view source/target dependencies. Default is disabled.
Group Source by Database
Displays sources grouped by database in the Navigator. Otherwise, sources appear in alphabetic order by source name, with the database name in parentheses.
Display Sources Using Business Names
Displays sources by business names in the Navigator. If you enable the option to display sources by business names, the Navigator displays the business names first, and then the source type name and table name in parentheses.
Display Targets Using Business Names
Displays targets by business names in the Navigator. If you enable the option to display targets by business names, the Navigator displays the business names first, then the target type name and table name in parentheses.
The directory for workspace files that are created by the Designer. Workspace files maintain the last source or target that you opened, or the last mapping that you saved. This directory should be a local directory to prevent file corruption or overwrites by multiple users. By default, the Designer creates files in the installation directory.
HTML Documentation Path or URL
HTML or URL path to enter links to business documentation.