Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Profiles
  3. Part 2: Profiling with Informatica Analyst
  4. Part 3: Profiling with Informatica Developer

Profile Guide

Profile Guide

Adding Columns to an Existing Scorecard

Adding Columns to an Existing Scorecard

After you run a profile, you can add columns to an existing scorecard.
  1. Click a profile to open it.
    The profile results appear in the summary view.
  2. Select a column. Click
    Actions
    Add to scorecard
    .
    The
    Add to Scorecard
    wizard appears.
    Use the following rules and guidelines before you add columns to a scorecard:
    • You cannot add a column to a scorecard if both the column name and scorecard name match.
    • You cannot add a column twice to a scorecard even if you change the column name.
  3. Select
    Existing Scorecard
    to add the columns to a predefined scorecard. Click
    Next
    .
  4. In the
    Step 2 of 7
    screen, select the scorecard that you want to add the columns to. Click
    Next
    .
    You can view the existing metrics and metric groups associated with the scorecard.
  5. In the
    Step 3 of 7
    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. Click
    Column Name
    to sort column names. Click
    Next
    .
  6. In the
    Step 4 of 7
    screen, you can create filters for the metrics. You can also apply the filter that you created for the profile to the metrics.
  7. In the
    Step 5 of 7
    screen, you can perform the following tasks:
    • In the
      Metrics
      pane, select each metric and configure metric values in the other panes.
    • In the
      Score using: Values
      pane, select multiple values in the
      Available Values
      pane, click the right arrow button to move the values 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, you can set thresholds for
      Good
      ,
      Acceptable
      , and
      Unacceptable
      scores.
    • In the
      Cost of invalid data
      , you can:
      • Select each metric and configure the cost of invalid data for the metric.
      • Select
        Fixed Cost
        option to assign a constant value to the cost for the metric. You can click
        Change Cost Unit
        to change the unit of cost.
      • Select
        Variable Cost
        option to attach a numeric column as a variable cost to the metric. You can click
        Select Column
        to select a numeric column.
  8. Click
    Next
    .
  9. In the
    Step 6 of 7
    screen, you can perform the following tasks:
    • Select the metric group to which you want to add the metrics.
    • In the
      Default - Metrics
      pane, you can double-click the default metric weight of 0 to change the value.
    • In the
      Metric Thresholds:
      pane, you can set thresholds for
      Good
      ,
      Acceptable
      , and
      Unacceptable
      scores.
  10. Click
    Next
    .
  11. In the
    Step 7 of 7
    screen, select a run-time environment.
  12. Click
    Save
    to save the scorecard, or click
    Save & Run
    to save and run the scorecard.

0 COMMENTS

We’d like to hear from you!