Database Reference
In-Depth Information
The components shown are as follows:
• Navigator (
1
)
• Workspace (
2
)
• Toolbar (
3
)
• Control panel (
4
)
• Status bar (
5
)
PowerCenter Designer has the following tools that allow us to work on different types of
sources, different types of targets, and build mappings using different types of transforma-
tions:
•
Source Analyzer
: This allows you to import or create source definitions. You can
work on various types of files (flat files, XML,
.xls
, and so on) and database
tables. Source Analyzer lets you modify the existing source definitions.
•
Target Designer
: This allows you to import or create target definitions. You can
work on various types of files (flat files, XML,
.xls
, and so on) and database
tables. Target Designer lets you modify the existing target definitions.
•
Transformation Developer
: This allows you to create reusable transformations
to use in mappings. Reusable components are important because they allow you
to use the existing transformations.