Exporting Metadata to Excel

Effective in version 9.5.0, the PowerCenter Repository Service does not export the Domains, Enumerations, Joins, Lookups, Filter, and Rules worksheet when you export metadata to Excel. The export of metadata to Excel is a reporting activity that represents a summary of the data lineage. The PowerCenter Repository Service exports the Models, Packages, and Mapping worksheets when you export metadata to Excel.

Previously, the PowerCenter Repository Service exported the worksheets by including the worksheets that do not have summary lineage, when you export metadata to Excel. The worksheets exported were Models, Packages, Domains, Enumerations, Mappings, Joins, Lookups, Filter, and Rules worksheet.