Table of Contents

Search

  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
    Library
    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
    Discovery
    workspace.
  3. Click
    Actions
    Add to scorecard
    .
    The
    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
    Next
    .
  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
    Next
    .
    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
    Next
    .
  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
      Next
      .
    • Select an existing filter. Click edit icon to edit the filter in the
      Edit Filter
      dialog box. Click
      Next
      .
    • Click the plus (+) icon to create filters in the
      New Filter
      dialog box.
      Click
      Next
      .
    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
    Next
    .
  9. In the
    Step 5 of 8
    screen, select each metric in the
    Metrics
    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
    screen:
    • 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
      pane.
    • In the
      Metric Thresholds
      pane, configure metric thresholds.
      You can set thresholds for
      Good
      ,
      Acceptable
      , and
      Unacceptable
      scores.
    • 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
      None
      . 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
    Next
    .
  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
    Native
    or
    Hadoop
    as the run-time environment to run the scorecard.
  13. Click
    Save
    to save the scorecard, or click
    Save & Run
    to save and run the scorecard.
    The scorecard appears in the
    Scorecard
    workspace.


Updated December 13, 2018