Custom PowerCenter Mappings and Workflows Rules and Guidelines
When you develop PowerCenter workflows, consider the following rules and guidelines:
Before you develop workflows for
Data Integration Hub
in PowerCenter, verify that the
Data Integration Hub
PowerCenter client and server plug-ins are installed and registered to the PowerCenter repository. For details, see the
Data Integration Hub
Installation and Configuration
Guide.
Name and store PowerCenter entities for custom mappings in different folders with a different naming convention from the naming convention of PowerCenter entities for custom mappings.
You can use user-defined session parameters in custom workflows and define their values in
Data Integration Hub
or in a parameter file. You can manage the values of user-defined session parameters in
Data Integration Hub
in the Forms Designer. You cannot manage the values of built-in session parameters in
Data Integration Hub
. For more information about session parameters, see the section "Working with Session Parameters" in the
PowerCenter Advanced Workflow Guide
.
Data Integration Hub
does not support session parameters in the format
$InputFile_$$CustomVariable
.
If you publish from a database source, you cannot use the following special characters in table names and in column names of a publication target: space ( ), dash (-), and period (.). The publication process replaces the characters with underscores (_).