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: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

Landing Table Properties

Landing Table Properties

Landing tables have the following properties.
Property
Description
Item Type
Type of table that you are adding. Select
Landing Table.
Display Name
Name of this landing table as it will be displayed in the
Hub Console
.
Physical Name
Actual name of the landing table in the database.
Informatica MDM Hub
will suggest a physical name for the landing table based on the display name that you enter.
Data Tablespace
Name of the data tablespace for this landing table. For more information, see the
Multidomain MDM Installation Guide
.
Index Tablespace
Name of the index tablespace for this landing table. For more information, see the
Multidomain MDM Installation Guide
.
Description
Description of this landing table.
Create Date
Date and time when this landing table was created.
Contains Full Data Set
Specifies whether this landing table contains the full data set from the source system, or only updates.
  • If selected (default), indicates that this landing table contains the full set of data from the source system (such as for the initial data load). When this check box is enabled, you can configure
    Informatica MDM Hub
    ’s delta detection feature so that, during the stage process, only changed records are copied to the staging table.
  • If not selected, indicates that this landing table contains only changed data from the source system (such as for incremental loads). In this case,
    Informatica MDM Hub
    assumes that you filtered out unchanged records
    before
    populating the landing table. Therefore, the stage process inserts
    all
    records from the landing table directly into the staging table. When this check box is disabled,
    Informatica MDM Hub
    ’s delta detection feature is not available.
You can change this property only when editing the source system properties.

0 COMMENTS

We’d like to hear from you!