Preface
Using Metadata Manager
- Using Metadata Manager Overview
  - Resource Types
- Metadata Manager Architecture
- Metadata Integration Process
- Working with Metadata Manager
- Metadata Manager Interface
  - Load Tab
  - Permissions Tab
Configuring Metadata Manager
- Configuring Metadata Manager Overview
- Step 1. Create and Configure the Metadata Manager Service
- Step 2. Install the Metadata Manager Agent
Application Resources
- SAP R/3 Resource Overview
- Configuring SAP R/3
- Creating an SAP R/3 Resource
  - SAP R/3 Configuration Properties
- Configuring the Component Inclusion List
- Reference
Business Glossary Resources
- Business Glossary Resources Overview
- Application Services Verification
- Creating a Business Glossary Resource
  - Business Glossary Connection Properties
- Business Glossary Objects Extracted
- Business Glossary Objects Not Extracted
Business Intelligence Resources
- Business Objects
- Cognos
- Microsoft Analysis and Reporting Services
- Microstrategy
- Oracle Business Intelligence Enterprise Edition
- Tableau
- Incremental Metadata Load
- Adding or Removing Metadata Files for a Resource
Custom Resources
- Configuring Custom Metadata Sources
- Creating a Custom Resource
- Configuring the Template Name
- Adding or Removing Metadata Files for a Resource
Data Integration Resources
- Informatica Platform Resources
- Microsoft SQL Server Integration Services Resources
- PowerCenter Resources
Data Modeling Resources
- Embarcadero ERStudio
- ERwin
- SAP PowerDesigner
- Adding or Removing Metadata Files for a Resource
- Reference for Data Modeling Resources
Database Management Resources
- Cloudera Navigator
- IBM DB2 for LUW
- IBM Db2 for z/OS
- IBM Informix
- JDBC
- Microsoft SQL Server
- Netezza
- Oracle
- Sybase ASE
- Teradata
- Configuring the Schema Inclusion List
- Data Lineage for Database Management Resources
  - Tables in Join Statements
  - SQL Inline Views
Universal Resources
- Universal Resources Overview
- Available Metadata Sources
- XConnect Creation
- Resource Creation
  - Step 1. Configure the Metadata Source
  - Step 2. Create the Resource
    - Metadata Extraction from a Source File
Managing Resources
- Managing Resources Overview
- Configure Connection Assignments
- Upload Rule Sets
  - Linking Rules Files
  - Uploading a Rule Set
- Purging Metadata
- Refreshing the Resources Panel
- Updating the Search Index
- Customizing the List of Words to Ignore in Searches
Loading and Monitoring Resources
- Loading and Monitoring Resources Overview
- Loading Resources
- Linking Objects Across Resources
- Monitoring Resources
- Logs and Log Files
- Troubleshooting Resource Loads
- Scheduling Resource Loads
Managing Permissions
- Managing Permissions Overview
- Configuring Permissions for Users and Groups
- Configuring Permissions on the Metadata Catalog
Resource Migration
- Resource Migration Overview
- Resource Migration Steps
- Step 1. Copy the Plug-in for a Universal XConnect
- Step 2. Migrate the Model
  - Exporting a Packaged or Universal Model
  - Importing a Packaged or Universal Model
- Step 3. Migrate the Resource Configuration
  - Exporting a Resource Configuration
  - Importing a Resource Configuration
- Step 4. Load the Resource
- Step 5. Migrate Resource Metadata
  - Exporting Resource Metadata
  - Importing Resource Metadata
Repository Migration
- Repository Migration Overview
- Migrating the Repository when Domain Names and Encryption Keys are the Same
- Migrating the Repository when Domain Names or Encryption Keys Differ
Appendix A: Metadata Manager Login
- Metadata Manager Login Overview
- Cookies
- Logging in to Metadata Manager
- Changing a Password
Appendix B: Metadata Manager Properties Files
- imm.properties
  - Metadata Manager Application Properties
  - Data Lineage Properties
- searchpriorities.xml
  - Search Result Configuration
  - Sample searchpriorities.xml File
Appendix C: Resource Configuration Files
- Resource Configuration Files Overview
- Resource Configuration File Format
- Passwords in Resource Configuration Files
- Secure JDBC Parameters in Resource Configuration Files
- Sample Resource Configuration File
Appendix D: Glossary
- Glossary of Terms

Metadata Manager Administrator Guide

10.5
- 10.5.7
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0

Back Next

Metadata Extraction Rules for Transformations

Metadata Manager extracts different metadata from the data flow based on the types of transformations that are present in the data flow.

Metadata Manager applies different metadata extraction rules when the following transformations are present in the data flow:

Audit transformation: This transformation adds columns to the data flow. Metadata Manager displays columns that originate from the source but not columns that are added by transformations in the data flow. Therefore, Metadata Manager does not update the target object with any column that the Audit transformation adds to the data flow.
Aggregate, Character Map, Data Conversion, Derived Column transformations: These transformations apply function expressions to columns values, for example,
AVG(SalesAmount)
or
UPPERCASE(LastName)
. Metadata Manager displays the function expressions in the
Operation
property in the target column. If multiple expressions apply to a target column, Metadata Manager concatenates the expressions.
Copy Column transformation: This transformation copies input columns and creates new columns in the transformation output. Because the copied columns originate from the source, Metadata Manager displays the new columns in the target.
Export Column transformation: This transformation inserts data into one or more flat files. Because the flat files originate from the transformation, Metadata Manager does not display them in the metadata catalog or in the data lineage diagram.
Fuzzy Lookup, Lookup, Term Lookup transformations: Metadata Manager displays the reference data set as a source object. Metadata Manager displays only the return columns in the reference data set.
Pivot transformation: In the Pivot transformation, each input column has a unique lineage ID and each output column has a source column. Metadata Manager creates a lineage link when the lineage ID value in an input column matches the source column value in an output column.
Script component: The Script component can be used as a source, target, or transformation. Metadata Manager groups all Script components under a connection called “_Scripts_” in the metadata catalog. Metadata Manager displays each Script component input and output group as a data set. It also displays each input and output column as a data attribute.

When the Script component is used as a source or target, Metadata Manager displays it in the data lineage diagram as a source or target object. When the Script component is used as a transformation, Metadata Manager uses the
Hide transformation scripts
configuration property to determine how to display the transformation logic.

Metadata Manager displays the transformation logic in the following ways based on the value of the
Hide transformation scripts
configuration property:

If the property is true, Metadata Manager does not display the transformation inputs or outputs. The data lineage diagram shows links between all columns in the source object and all columns in the target object.
If the property is false, Metadata Manager creates a separate object in the lineage diagram to represent each input or output group of a transformation script. The data lineage diagram displays links between the source object and the transformation script inputs and between the transformation script outputs and the target. However, it does not display links between the transformation script inputs and outputs. To define the flow of metadata within a transformation script, use rule-based links or enumerated links to link data attributes to each other. You can also use rule-based links or enumerated links to link transformation scripts to other metadata objects.

Rename Saved Search

Table of Contents

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Metadata Extraction Rules for Transformations

Metadata Extraction Rules for Transformations