Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Viewing Metadata
  4. Searching Metadata
  5. Working with Shortcuts and Folders
  6. Editing Metadata
  7. Working with Data Lineage
  8. Sharing Metadata
  9. Business Glossaries
  10. Using the URL API
  11. Appendix A: Configure the Web Browser
  12. Appendix B: Glossary

Metadata Manager User Guide

Metadata Manager User Guide

Field-Level Information Worksheet

Field-Level Information Worksheet

The Field-Level Information worksheet contains properties for the resources and fields in a data lineage diagram.
A field is a child object for a metadata object. The fields are organized by resource name to show all fields for a resource. The worksheet contains a section for each resource and the fields in that resource for each parent object. The resources, parent objects, and fields appear in the same order as the metadata catalog. Use this worksheet to get details about an individual field in a data lineage diagram.
The properties for each resource in the worksheet depend on the resource type. For example, Oracle resource properties include resource name, resource type, and schema name.
Metadata Manager exports all properties that appear in the Details panel when you view a field. The properties depend on the object type. The properties appear below the row that contains the field.
The following table describes the properties for all fields:
Property
Description
Parent Object Name
Parent object for the field.
Parent Object Class
Parent object class for the field.
Field Name
Name of the field in the metadata catalog.
Business Name
Business name for the field.
Location
Location of the field in the metadata catalog.
Expression
Expression that defines the value for the field.
Description
Description for the field.
Source Creation Date
Date the field was created in the metadata source system.
Source Update Date
Date the field was modified in the metadata source system.
MM Creation Date
Date the field was loaded into the metadata catalog.
MM Update Date
Date the field was updated in the metadata catalog.
Endpoint
Indicates if the object is an upstream or downstream endpoint in the data lineage diagram. An endpoint indicates that the field does not have any links to other structures or fields upstream or downstream from the current field.
Connections
Hyperlink to the list of connections for the parent object in the Connections By Structure worksheet.
In addition, Metadata Manager exports all properties that appear in the Details panel when you view a metadata object. The properties depend on the object type. The properties appear below the row that contains the field.
Use the following rules and guidelines when you view the field-level properties:
  • A field is an upstream endpoint if it does not have any upstream connection.
  • A field is a downstream connection if it does not have any downstream connection.
  • PowerCenter mappings and mapplets appear with the following syntax:
    <mapping name> : <session name>

0 COMMENTS

We’d like to hear from you!