Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Choosing Sources for the Mappings

Choosing Sources for the Mappings

Use the following sources with a mapping wizard:
  • Flat file
  • Relational
  • Application
  • Shortcut to a flat file, relational, or Application sources
You cannot use COBOL or XML sources with the mapping wizards.
When you select a source for a mapping, the mapping wizards display all available sources by source name. The Designer can optionally display sources and target definitions by business name, rather than source and target name. Even when this option is selected, mapping wizards display sources by source name.
The Mapping Wizard cannot import a source when a column name uses an SQL keyword. When the Mapping Wizard encounters an SQL keyword used as a column name, it prompts you to choose another source. If you want to use a source with a column using an SQL keyword, create the mapping in the Mapping Designer.
The mapping wizards also complete the following based on the selected source:
  • Use the source name to name the source qualifier as follows: SQ_
    SourceName
    for file or relational sources, or ASQ_
    SourceName
    for Application sources.
  • Create port names based on source column names.


Updated June 25, 2018