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

Deleting Columns

Deleting Columns

Deleting columns should be approached with extreme caution. Any data loaded into a column is lost when the column is removed. Deleting a column can be a slow process due to the number of underlying tables that could be affected.
To delete a column from base objects and landing tables:
  1. In the Hub Console, start the Schema tool.
  2. Navigate to the column editor for the table that you want to configure.
  3. Acquire a write lock.
  4. Select the column that you want to delete from the list of column definitions in the Properties pane.
  5. Click the
    Remove Column
    button.
    The column is analyzed and the Impact Analyzer is displayed.
  6. Click
    OK
    in the Impact Analyzer to delete the column.
    The Schema tool removes the column.
  7. Click the
    Save
    button to save your changes.

0 COMMENTS

We’d like to hear from you!