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 Columns

Landing Table Columns

Landing tables have user-defined columns, which are columns that are added by users. Also, landing tables have the SRC_ROWID system column, which uniquely identifies the landing table records.
The SRC_ROWID values help trace if a record has been loaded by the stage process. The values of the SRC_ROWID column must be unique. If duplicate values exist in the SRC_ROWID column, the stage job fails. Contact Informatica Global Customer Support if duplicate values exist in the SRC_ROWID column.
If the source system table has a multiple-column key, concatenate these columns to produce a single unique VARCHAR value for the primary key column.

0 COMMENTS

We’d like to hear from you!