Create, Edit, and Maintain Reference Data Tables with Reference Table Manager

Reference Table Manager, a key feature of Informatica PowerCenter Standard Edition, simplifies and streamlines the creation and management of reference data. With this feature, business analysts and other subject matter experts can create, edit, and maintain reference data tables. Your IT organization can then use these reference tables to migrate data and to manage lookup tables used in data warehousing, data migration, and other data integration initiatives.

  • Reduce the risk of errors, inconsistencies, and compliance breaches by centralizing management of key reference data
  • Accelerate project delivery by eliminating labor-intensive, spreadsheet-based capture of reference data
  • Strengthen the collaboration between IT and the business by empowering business analysts to directly manage reference data while IT maintains control of the data integration process

Reference Table Manager Key Features

  • Robust reference table management for all types of reference data, including default values, valid values, and cross-reference mapping data values
  • Easy-to-use interface for business analysts and other subject matter experts to create, edit, and delete reference tables
  • Manual edit capabilities to edit reference data prior to data migration
  • Audit trails to document changes to reference tables
  • Import/export capabilities that handle reference tables as .csv