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: Glossary

Queries and Packages Overview

Queries and Packages Overview

In
MDM Hub
, a query is a request to retrieve data from the
Hub Store
. The request is in the form of an SQL SELECT statement. When you run a query, the
MDM Hub
sends the query SQL statement to the database that contains the
Hub Store
, and the database returns the results of the query. A package is a public view of the results of the query.
Generic Queries
A generic query is a type of query that you define by using a query wizard and building blocks. No SQL knowledge is required. The Queries tool generates an SQL SELECT statement from the selected building blocks. The generated SELECT statement works with all supported databases.
Custom Queries
A custom query is a type of query where you define your own SQL SELECT statement. When you want to use database-specific SQL syntax and grammar, create a custom query.
Query Groups
A query group is a user-defined container for queries. Use query groups to organize your queries so that they are easier to find and run.
If you create query groups before you create queries, you can select a group when you create a query.
Packages
A package is a public view of the results of a query. Data stewards use packages with the Data Manager and Merge Manager tools. You can also use packages with external applications.

0 COMMENTS

We’d like to hear from you!