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

Creating an Expression Rule

Creating an Expression Rule

Use the
Profile
wizard to create an expression rule and add it to a profile. Create an expression rule to validate values for columns in a profile.
  1. Open a profile.
  2. In the summary view, click
    Actions
    Edit Profile
    to open the
    Profile
    wizard.
  3. Click
    Specify Rules and Filters
    .
  4. In the Rules pane, click
    Actions
    Add a Rule
    .
    The
    New Rule
    dialog box appears. This image shows the new rule wizard. You can add a name, optional description, and parameters for the rule in this wizard. You can save this rule as a resusable rule.
  5. In the
    New Rule
    dialog box, enter a name and an optional description for the rule. You can create a rule in the Functions panel or Columns panel.
    • In the Functions panel, select a function category, and click the right arrow (>>) button. In the dialog box, specify parameters, and click
      OK
      .
      The function along with the columns and values appears in the Expression panel.
    • In the Columns panel, select a column, and click the right arrow (>>) button. The column appears in the Expression panel. Add functions, expressions, and values to create a rule.
  6. To verify the rule, click
    Validate
    .
  7. Optionally, choose to promote the rule as a reusable rule and configure the project and folder location. If you promote a rule to a reusable rule, you or other users can use the rule in another profile as a predefined rule.
  8. Click
    OK
    .
    The
    Specify Rules and Filters
    screen appears with the rule in the Rules pane.

0 COMMENTS

We’d like to hear from you!