PowerCenter is an
ETL tool used to build enterprise data warehouses.
Main components
- client tools
- server
- repository server
- repository
Work flow managers create work flows.
Work flows can be monitored in work flow monitors.
A
mapping defines how
data flows and is transformed between source to target. Mappings are created in a
mapping designer.
Typical transformations are:
- aggregation
- filtering
- joining