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 SQL conversion files

Configuring the SQL conversion files

Configure the SQL conversion configuration files to generate converted SQL queries for the target endpoint.
  1. Open the assessment output ZIP file and extract the content.
  2. Go to the
    TEMPLATES
    >
    SqlQueries
    folder and open the
    MasterSql.xlsx
    file.
  3. Select the folder that contains the SQL queries and click the link to open the ConvertSql file.
  4. Enter the converted query for the target endpoint in the CONVERTED_SQL column.
  5. Save the file.
Use the ConvertSql file to create a properties conversion configuration. Conversion tasks use the configuration to generate converted queries for the target endpoints.
You must enter an advanced property to use the ConvertSql files in the properties conversion configuration. For more information, contact Informatica Global Customer Support.

0 COMMENTS

We’d like to hear from you!