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

Assessment output files

Assessment output files

When you download the reports for an assessment job,
CDI-PC
downloads a zip file containing assessment reports, log files, and configuration templates. Some of these files are used as inputs in the conversion process.
The following table contains the list of output files and their contents:
File Name
User Action
Contents
<Repository_Name>_ASSESSMENT_SUMMARY
Review
Review the assessment summary file to view detailed information about the assessment result. For more information on the assessment report, see the Assessment report topic.
Command_List.xlsx
Review
Review the
Command_List.xlsx
file to verify the commands used in the workflows.
File_List.xlsx
Review
Review the
File_List.xlsx
file to verify list of flat files used in the workflows with their source and target directories.
Parameter_Files.xlsx
Review
Review the
Parameter_Files.xlsx
file to verify the details of the workflow and session parameter files, such as name file name, location, and task type.
Sql_List.csv
Review
Review the
Sql_List.csv
file to view the list of SQL queries used in the transformations.
Xml_Pre_Processing_Configuration.xlsx
Use as input for conversion
Configure the
Xml_Pre_Processing_Configuration.xlsx
file to specify additional attributes for the conversion process, such as names for duplicate worklets, session level attributes, and connection sub type. For more information on configuring the XML Pre-processor file, see the
Configuring the XML Pre-processor file
topic.
Connection_Details.xlsx
Review
Review the
Connection_Details.xlsx
file to verify the list of PowerCenter connections available in the repository. If you want to migrate your assets to a different endpoint, you can create a Connection Map configuration to map the PowerCenter connections to specific cloud connections. For information on creating a Connection Map configuration, see the
Creating a Connection Map configuration
topic.
Conversion_Configuration.properties
Review
Review the
Conversion_Configuration.properties
file to verify the conversion properties and their default values. You can create a Conversion Properties configuration to override these default values. For information on creating a Conversion Properties configuration, see the
Creating a Conversion Properties configuration
topic.
MULTI_SESSION_PC2C_FILE.xlsx
Use as input for conversion
Configure the
MULTI_SESSION_PC2C_FILE.xlsx
file to specify multi-session mappings where sessions are present across different workflows. For more information on configuring the XML Pre-processor file, see the
Configuring the XML Pre-processor file
topic.
<Repository_Name>_SQL_ELT_Summary
Review
Review the SQL ELT pattern summary to get a list of mapping and maplets in the repository that follow SQL ELT rules and are being repointed to Snowflake.
MasterSql.xlsx
Review
Review the master SQL conversion file to get a list of folders in the repository that contain the SQL queries.
ConvertSql<file_number>.xlsx
Use as input for conversion
Configure the
ConvertSql.xlsx
files to specify the converted SQL queries. For more information on configuring the SQL conversion files, see
Configuring the SQL conversion files
.

0 COMMENTS

We’d like to hear from you!