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

About Landing Tables

About Landing Tables

A landing table provides intermediate storage in the flow of data from source systems into
Informatica MDM Hub
. In effect, landing tables are “where data lands” from source systems into the
Hub Store
. You use the Schema Manager in the Model workbench to define landing tables.
The manner in which source systems populate landing tables with data is entirely external to
Informatica MDM Hub
. The data model you use for collecting data in landing tables from various source systems is also external to
Informatica MDM Hub
. One source system could populate multiple landing tables. A single landing table could receive data from different source systems. The data model you use is entirely up to your particular implementation requirements.
Inside
Informatica MDM Hub
, however, landing tables are mapped to staging tables. It is in the staging table—mapped to a landing table—where the source system supplying the data to the base object is identified. During the load process,
Informatica MDM Hub
copies data from a landing table to a target staging table, tags the data with the source system identification, and optionally cleanses data in the process. A landing table can be mapped to one or more staging tables. A staging table is mapped to only one landing table.
Landing tables are populated using batch or real-time approaches that are external to
Informatica MDM Hub
. After a landing table is populated, the stage process pulls data from the landing tables, further cleanses the data if appropriate, and then populates the appropriate staging tables.

0 COMMENTS

We’d like to hear from you!