Table of Contents


  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

Refining a Generic Query

Refining a Generic Query

After you create a generic query, you can refine the query by using the building blocks. Edit the query to open the building blocks. Each building block is contained on a tab in the properties pane.
The following table lists the tabs, describes the building blocks, and identifies the equivalent SQL syntax:
Tab Name
Building Block Description
SQL Syntax
Tables associated with this query.
FROM clause
Columns associated with this query. You can add functions and constants to the columns.
<list of columns>
Conditions associated with this query. Determines selection criteria for individual records.
WHERE clause
Sort order for the results of this query.
ORDER BY clause
Grouping for the results of this query.
GROUP BY clause
Displays the SQL statement that is generated from the selected building blocks.
SELECT statement with all clauses


We’d like to hear from you!