Table of Contents


  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. Appendix A: Datatype Reference
  17. Appendix B: Configure the Web Browser

Designer Toolbars

Designer Toolbars

You can configure the Designer to display the following toolbars:
  • Standard.
    Contains buttons to connect to and disconnect from repository and folders, and to toggle views and columns.
  • Repository.
    Contains buttons to connect to and disconnect from repositories and folders, export and import objects, save changes, and print the workspace.
  • View.
    Contains buttons to configure toolbars, toggle windows, toggle full-screen view, change workspace mode, and view properties.
  • Layout.
    Contains buttons to iconize, and arrange repository objects, copy, link, and move columns, and zoom in/out of the workspace.
  • Mappings/Mapplets.
    Contains buttons to create, edit, and parse mappings and mapplets.
  • Transformations.
    Contains buttons to create transformations.
  • Advanced Transformations.
    Contains buttons to create advanced transformations.
  • Versioning.
    Contains buttons to check in objects, undo checkouts, find checkouts, view history, undo labels, and manage queries.
  • Debugger.
    Contains buttons to start, stop, and continue the Debugger.
  • Tools.
    Contains buttons to connect to the other PowerCenter Client applications. When you use a Tools button to open another PowerCenter Client application, PowerCenter uses the same repository connection to connect to the repository and opens the same folders.
If you do not see all buttons in the toolbar, you can configure the toolbar.

Updated March 29, 2021