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

Rejected Records in Load Jobs

Rejected Records in Load Jobs

During the load process, records in the staging table might be rejected for the following reasons:
  • future date or NULL date in the LAST_UPDATE_DATE column
  • LAST_UPDATE_DATE less than 1900
  • NULL value mapped to the PKEY_SRC_OBJECT of the staging table
  • duplicates found in PKEY_SRC_OBJECT
  • invalid value in the HUB_STATE_IND field (for state-enabled base objects only)
  • invalid or NULL foreign keys.
Rejected records will not be loaded into base objects. Rejected records can be inspected after running Load jobs.
To reject records, the load process requires traceability back to the landing table. If you are loading a record from a staging table and its corresponding record in the associated landing table has been deleted, then the load process does not insert it into the reject table.

0 COMMENTS

We’d like to hear from you!