PowerCenter Designer

PowerCenter Designer
The Designer has the following tools that you use to analyze sources, design target schemas, and build source-to-target mappings:

•   Source Analyzer. Import or create source definitions.
•   Target Designer. Import or create target definitions.
•   Transformation Developer. Develop transformations to use in mappings. You can also develop user- defined functions to use in expressions.
•   Mapplet Designer. Create sets of transformations to use in mappings.
•   Mapping Designer. Create mappings that the Integration Service uses to extract, transform, and load data.

You can display the following windows in the Designer:
•   Navigator. Connect to repositories and open folders within the Navigator. You can also copy objects and create shortcuts within the Navigator.
•   Workspace. Open different tools in this window to create and edit repository objects, such as sources, targets, mapplets, transformations, and mappings.
•   Output. View details about tasks you perform, such as saving your work or validating a mapping.