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

SQL Validation

SQL Validation

When you save a custom query, the
MDM Hub
performs client-side validation of the SQL statement and then sends the SQL statement to the database for further validation.
Client-side SQL Validation
The
MDM Hub
validates that the SQL statement meets the SQL syntax required by the
MDM Hub
. For example, the client-side validation process checks that the statement begins with the keyword SELECT and the column names do not contain spaces or special characters. If the validation process finds an error, the process displays an error message.
Database-side SQL Validation
When the database receives the SQL statement, the database verifies that the syntax and grammar of the SQL statement meet the requirements of the database. If the SQL statement generates an error, the database returns the error to the
MDM Hub
, and the
Hub Console
displays the database error.

0 COMMENTS

We’d like to hear from you!