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

Custom Queries

Custom Queries

A
custom query
is a query for which you supply the SQL statement directly, rather than building it. Custom queries can be used in display packages. You can create custom queries against any object.
If you use a proxy user in an IBM DB2 environment, ensure that the proxy user has access to the objects in a query. If the
Repository Manager
does not have metadata for all the objects in a query, the
Repository Manager
migration can result in privilege warnings for a query. To fix the warnings, manually grant the proxy user access to the objects.

0 COMMENTS

We’d like to hear from you!