Review the SQL conversion configuration files that are generated after assessing a PowerCenter repository.
The SQL conversion configuration files retrieve SQL details from the assessment of PowerCenter repositories. You can specify the converted SQL queries for the target endpoint and use the files to generate converted SQL queries. For example, to repoint an Oracle query to a Snowflake query, specify the converted SQL query for Snowflake in the configuration files and use the files to create a conversion properties configuration. Use the conversion properties configuration to create a parameter file conversion task, and then run the task to generate the converted queries.
You can find the SQL conversion configuration files in the SqlQueries folder of the downloaded assessment ZIP file. The SqlQueries folder contains the following types of files:
MasterSql
This file contains a list of folders in the repository that contain the SQL queries. The folders are organized into separate ConvertSql files, with each file containing the SQL details of 10 folders. The Link column contains direct links for easy access to the respective ConvertSql files.
ConvertSql<file_number>
This file contains the existing SQL queries in the folders. To convert an SQL query, specify the converted query in the CONVERTED_SQL column.
Configuring the SQL conversion files
Configure the SQL conversion configuration files to generate converted SQL queries for the target endpoint.
1Open the assessment output ZIP file and extract the content.
2Go to the TEMPLATES > SqlQueries folder and open the MasterSql.xlsx file.
3Select the folder that contains the SQL queries and click the link to open the ConvertSql file.
4Enter the converted query for the target endpoint in the CONVERTED_SQL column.
5Save 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.
Note: You must enter an advanced property to use the ConvertSql files in the properties conversion configuration. For more information, contact Informatica Global Customer Support.