Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Data Discovery
  3. Part 2: Data Discovery with Informatica Analyst
  4. Part 3: Data Discovery with Informatica Developer
  5. Appendix A: Function Support Based on Profiling Warehouse Connection

Data Discovery Guide

Data Discovery Guide

Running an Enterprise Discovery Profile

Running an Enterprise Discovery Profile

You can run an enterprise discovery profile in multiple ways. You can run the profile from the
Object Explorer
view or from the
Profiles
tab in the
Properties
window. You can choose to run individual and multiple profile tasks that form a part of the enterprise discovery profile.
  1. In the
    Object Explorer
    view, select the project or folder that contains the profile that you want to run.
    To run a profile automatically, select
    Run enterprise discovery profile on finish
    in the
    New Enterprise Discovery
    wizard when you create the profile.
  2. Double-click the profile to open it.
    The profile opens in a tab.
  3. In the
    Object Explorer
    view, right-click the profile and select
    Run Enterprise Discovery Profile
    .
    Alternatively, you can select
    Profiles
    in the
    Properties
    window, select the profile name under the
    List of profiling tasks
    , and then click
    Run
    .
    When you run an enterprise discovery profile, you need to refresh the Model Repository Service before you can view the results. This step is required as the import of metadata for external connections happens in the Model repository. You need to refresh the Model Repository Service so that the Developer tool reflects the changes to the Model repository.
  4. The
    Run
    dialog box appears. You can make changes to the global settings of the profile in this dialog box.
    By default, the changes you make apply to the newly added data objects in the enterprise discovery profile.
  5. To apply the changes to all the data object profile tasks and the system-generated foreign key profile task in the enterprise discovery profile, select
    Use global settings for current profiles
    .
    The Developer tool updates all the data object profile tasks and the foreign key profile task based on the changed settings.
  6. To run individual profile tasks, select a task and click
    Run
    .
  7. To run multiple profile tasks, click
    Run Multiple
    .
    The
    Run Multiple
    dialog box appears.
    If the enterprise discovery results take a long time to load, you might want to update the statistics of the profiling warehouse database. Multiple enterprise discovery profile runs can result in significant changes to data volume and column values. When you update the statistics, the database runs an execution plan for the SQL queries based on the latest statistics and optimizes the database operations.
  8. All tasks are selected by default. Clear the tasks that you do not want to run and click
    OK
    .

0 COMMENTS

We’d like to hear from you!