Using Business Names as Port Names in Source Qualifiers
Using Business Names as Port Names in Source Qualifiers
Use business names of source columns as port names in Source Qualifier transformations.
To add business names to existing Source Qualifiers in a mapping, you must enable the option to display business names. Then delete the existing source and reimport it with the Source Qualifier.
If the source has no business names, the Source Qualifier contains the port names. If the business name contains characters that are not allowed as a port name, the Designer replaces each of the characters with an underscore (_). Business names usually contain spaces between words, which is not allowed in a port name. For example, the business name Employee Data becomes Employee_Data.
Avoid using PowerCenter reserved words, such as DD_INSERT, for business and port names.