Table of Contents

Search

  1. Preface
  2. Getting started with PowerCenter modernization
  3. Repository Assessment
  4. Asset Conversion
  5. Bulk Metadata Update
  6. Jobs
  7. Configurations

PowerCenter Modernization

PowerCenter Modernization

Configuring the XML Pre-processor file

Configuring the XML Pre-processor file

Configure this file to specify additional attributes for the conversion process, such as names for duplicate worklets, and session level attributes.
  1. Open the
    Xml_Pre_Processing_Configuration.xlsx
    file from the following location:
    <SharedFolder>/<DomainDisplayName>/<RepositoryName>/Templates/Xml_Pre_Processing_Configuration.xlsx
  2. Configure the required parameters.
    The following table lists the sheets in the
    Xml_Pre_Processing_Configuration.xlsx
    along with the description for each sheet:
    Sheet Name
    Description
    DUPLICATE_WORKFLOW_WORKLET
    Contains a list of duplicate workflow and worklet combinations available in the repository. Use the DUPLICATE_WORKFLOW_WORKLET sheet to specify new names for the duplicate workflow and worklet combinations.
    CHANGE_TARGET_DB_TYPE
    Use the CHANGE_TARGET_DB_TYPE sheet to change the target database type during asset conversion.
    UPDATE_CONNECTION_SUBTYPE
    Use the UPDATE_CONNECTION_SUBTYPE sheet to specify the connection sub types for a connection.
    DUPLICATE_WORKLET_NAME
    Contains a list of duplicate worklets available in the repository. Use the DUPLICATE_WORKLET_NAME sheet to specify a new name for a duplicate worklet.
    DUPLICATE_EVENT_WAIT_TIME
    Contains a list of duplicate event wait tasks. Use the DUPLICATE_EVENT_WAIT_TIME sheet to specify new event names for the duplicate events.
    STANDARDIZE_RULE_INFO
    Contains a list of rules to use with business data.
    ADD_SESSION_LEVEL_ATTRIBUTES
    Use the ADD_SESSION_LEVEL_ATTRIBUTES sheet to update the session level properties.
    DUPLICATE_SESSION_INSTANCE_NAME
    Contains a list of duplicate session instance names available in the repository. Use the DUPLICATE_SESSION_INSTANCE_NAME sheet to specify new names for the duplicate session instance names.
  3. Save the file.
    The conversion process uses this file update specified attributes.

0 COMMENTS

We’d like to hear from you!