Table of Contents


  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Connections
  4. Mappings in the Hadoop Environment
  5. Mapping Objects in the Hadoop Environment
  6. Processing Hierarchical Data on the Spark Engine
  7. Stateful Computing on the Spark Engine
  8. Monitoring Mappings in the Hadoop Environment
  9. Mappings in the Native Environment
  10. Profiles
  11. Native Environment Optimization
  12. Data Type Reference
  13. Complex File Data Object Properties
  14. Function Reference
  15. Parameter Reference

Creating a Scorecard in Informatica Analyst

Creating a Scorecard in Informatica Analyst

Create a scorecard and add columns from a profile to the scorecard. You must run a profile before you add columns to the scorecard.
  1. In the
    workspace, select the project or folder that contains the profile.
  2. Click the profile to open the profile.
    The profile results appear in the summary view in the
  3. Click
    Add to scorecard
    Add to Scorecard
    wizard appears.
  4. In the
    Add to Scorecard
    screen, you can choose to create a new scorecard, or edit an existing scorecard to add the columns to a predefined scorecard. The
    New Scorecard
    option is selected by default. Click
  5. In the
    Step 2 of 8
    screen, enter a name for the scorecard. Optionally, you can enter a description for the scorecard. Select the project and folder where you want to save the scorecard. Click
    By default, the scorecard wizard selects the columns and rules defined in the profile. You cannot add columns that are not included in the profile.
  6. In the
    Step 3 of 8
    screen, select the columns and rules that you want to add to the scorecard as metrics. Optionally, click the check box in the left column header to select all columns. Optionally, select
    Column Name
    to sort column names. Click
  7. In the
    Step 4 of 8
    screen, you can add a filter to the metric.
    You can apply the filter that you created for the profile to the metrics, or create a new filter. Select a metric in the
    Metric Filters
    pane, and click the
    Manage Filters
    icon to open the
    Edit Filter:
    column name
    dialog box. In the
    Edit Filter:
    column name
    dialog box, you can choose to perform one of the following tasks:
    • You can choose a filter that you created for the profile. Click
    • Select an existing filter. Click edit icon to edit the filter in the
      Edit Filter
      dialog box. Click
    • Click the plus (+) icon to create filters in the
      New Filter
      dialog box.
    The filter appears in the
    Metric Filters
    pane. You can apply the same filter to all the metrics in the scorecard.
  8. In the
    Step 4 of 8
    screen, click
  9. In the
    Step 5 of 8
    screen, select each metric in the
    pane and configure the valid values from the list of all values in the
    Score using: Values
    pane. You can perform the following tasks in the
    Step 5 of 7
    • You can select multiple values in the
      Available Values
      pane, and click the right arrow button to move them to the
      Valid Values
      pane. The total number of valid values for a metric appears at the top of the
      Available Values
    • In the
      Metric Thresholds
      pane, configure metric thresholds.
      You can set thresholds for
      , and
    • Select each metric and configure the cost of invalid data. To assign a constant value to the cost for the metric, select
      Fixed Cost
      . Optionally, click
      Change Cost Unit
      to change the unit of cost or choose
      . To attach a numeric column as a variable cost to the metric, select
      Variable Cost
      , and click
      Select Column
      to select a numeric column.
  10. In the
    Step 6 of 8
    screen, you can select a metric group to which you can add the metrics, or create a new metric group, To create a new metric group, click the group icon. Click
  11. In the
    Step 7 of 8
    screen, specify the weights for the metrics in the group and thresholds for the group.
  12. In the
    Step 8 of 8
    screen, select
    as the run-time environment to run the scorecard.
  13. Click
    to save the scorecard, or click
    Save & Run
    to save and run the scorecard.
    The scorecard appears in the

Updated December 13, 2018