Table of Contents

Search

  1. Introduction
  2. Configuring Hub Console Tools
  3. Building the Data Model
  4. Configuring the Data Flow
  5. Executing Informatica MDM Hub Processes
  6. Configuring Application Access
  7. MDM Hub Properties
  8. Viewing Configuration Details
  9. Search with Solr
  10. Row-level Locking
  11. MDM Hub Logging
  12. Table Partitioning
  13. Collecting MDM Environment Information with the Product Usage Toolkit
  14. Glossary

Adding a Generic Query

Adding a Generic Query

If you want to use the building blocks to construct a query that can be understood by any of the supported databases, add a generic query.
If you want to code an SQL statement, add a custom query instead.
  1. In the
    Model
    workbench, click
    Queries
    .
  2. Acquire a write lock.
  3. Optionally, in the navigation pane, select the query group to which you want to add the query.
  4. Right-click in the navigation pane and click
    New Query
    .
    The
    New Query Wizard
    opens.
  5. If you see a
    Welcome
    screen, click
    Next
    .
  6. Specify the general query properties, and click
    Next
    :
    Property
    Description
    Query name
    Type a descriptive name for the query.
    Description
    Optionally, type a description for the query.
    Query Group
    Optionally, select a different query group.
    Select primary table
    Select the table from which you want to retrieve data.
  7. If you want to retrieve a subset of columns, select the columns:
    1. In the
      Select query columns
      screen, select the columns to include and clear the check boxes for all other columns.
    2. If you intend to use the query in a PUT-enabled package, select the
      Rowid Object
      column.
      The Rowid Object is a required column for PUT-enabled packages.
  8. Click
    Finish
    .
    The query appears within the selected query group.
  9. To view the results of the query, in the navigation pane, expand the query and click
    View
    .
    The Queries tool displays the results of the query.
To further refine the query, edit the query and use the query building blocks.

0 COMMENTS

We’d like to hear from you!