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

Maintenance of Queries and Packages

Maintenance of Queries and Packages

If you change the database schema after you create queries and packages, the
MDM Hub
updates queries and packages. The update depends on the type of schema change. You might need to edit some queries and packages manually.
The following table lists the types of schema changes, describes the actions taken by the
MDM Hub
, and notes any actions that you need to perform:
Schema Change
Generic Queries and Packages
Custom Queries and Packages
Revised column name
Updates the generic queries and packages to use the revised column name.
Updates the custom queries and packages to use the revised column name.
Deleted column
Removes the deleted column from the generic queries and packages.
Custom queries are not updated. The custom queries and packages that use the deleted column are no longer valid.
You must edit the queries and packages to remove the deleted column.
Deleted base object
Deletes the generic queries and packages that use the deleted base object.
Custom queries are not updated. The custom queries and packages that use the deleted base object are no longer valid.
You must delete the queries and the dependent packages.

0 COMMENTS

We’d like to hear from you!