Cloud Data Integration for PowerCenter
- Cloud Data Integration for PowerCenter
- All Products
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 . |