Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Data Engineering Integration
  3. Mappings
  4. Mapping Optimization
  5. Sources
  6. Targets
  7. Transformations
  8. Python Transformation
  9. Data Preview
  10. Cluster Workflows
  11. Profiles
  12. Monitoring
  13. Hierarchical Data Processing
  14. Hierarchical Data Processing Configuration
  15. Hierarchical Data Processing with Schema Changes
  16. Intelligent Structure Models
  17. Blockchain
  18. Stateful Computing
  19. Appendix A: Connections Reference
  20. Appendix B: Data Type Reference
  21. Appendix C: Function 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:
    • Choose a filter that you created for the profile. Click
      Next
      .
    • Select an existing filter. Click the 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
      .
    Optionally, you can choose to apply the selected filters to all the metrics in the scorecard.
    The filter appears in the
    Metric Filters
    pane.
  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 to perform the following tasks:
    • Configure valid values. In the
      Score using: Values
      pane, select one or more 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.
    • Configure metric thresholds. In the
      Metric Thresholds
      pane, set the thresholds for
      Good
      ,
      Acceptable
      , and
      Unacceptable
      scores.
    • Configure the cost of invalid data. To assign a constant value to the cost for the metric, select
      Fixed Cost
      . To attach a numeric column as a variable cost to the metric, select
      Variable Cost
      , and click
      Select Column
      to select a numeric column. Optionally, click
      Change Cost Unit
      to change the unit of cost. If you do not want to configure the cost of invalid data for the metric, choose
      None
      .
  10. Click
    Next
    .
  11. 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
    .
  12. In the
    Step 7 of 8
    screen, specify the weights for the metrics in the group and thresholds for the group.
  13. In the
    Step 8 of 8
    screen, select
    Native
    ,
    Hadoop
    , or
    Databricks
    as a run-time environment to run the scorecard. You can choose a
    Blaze
    or
    Spark
    engine in the Hadoop run-time environment. If you choose the
    Databricks
    ,
    Browse
    to choose a Databricks connection to run the profile. click If you choose the
    Blaze
    or
    Spark
    engine, click
    Browse
    to choose a Hadoop connection to run the profile.
  14. Click
    Save
    to save the scorecard, or click
    Save & Run
    to save and run the scorecard.
    The scorecard appears in the
    Scorecard
    workspace.

0 COMMENTS

We’d like to hear from you!