Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

Defining Comparison Conditions

Defining Comparison Conditions

You can define comparison conditions in a query. A comparison condition has a column, an SQL comparison operator, and another column or a constant. When you run the query, the query compares the values in the column against the condition, and returns records that satisfy the condition.
When the data in a column is encrypted, you cannot create conditions that use strings or wildcard characters.
  1. In the properties pane, click the
    Conditions
    tab.
  2. Click the
    Add
    icon.
    The
    Add Comparison
    dialog box opens.
  3. In the Column field, select the column on which you want to define a comparison.
  4. In the Operator field, select an SQL comparison operator.
  5. Select the target of the comparison, which can be another column or a constant.
    • If you select
      Column
      , select the column from the Edit Column list.
    • If you select
      Constant
      , the default value is NULL. To change the value, click the
      Edit
      icon, select a data type, and if the Value field appears, enter a value.
    For example, the following image shows a comparison condition that compares values in the column LAST_NAME with the string %JO%:
    The Add Comparison dialog box contains the following condition: the column is C_B_PARTY - LAST_NAME, the operator is an equal sign, the type is Constant, and the value is %JO%.
    When you run the query, the query returns records with values like “Johnson”, “Vallejo”, and “Major”.
  6. Click
    OK
    .
    The condition appears in the table.
  7. Optionally, you can edit, reorder, or remove conditions.
    Option
    Description
    Edit
    Select the condition, and click the
    Edit
    icon.
    Reorder
    Select the condition, and click the
    Move Up
    or
    Move Down
    icon.
    Remove
    Select the condition, and click the
    Delete
    icon.
  8. Click the
    Save
    icon.

0 COMMENTS

We’d like to hear from you!