Glossary
- PowerCenter Products:
- Designer: Create mappings
- Workflow Manager: create and run workflows
- Workflow Monitor: monitor and control workflows
- Mapping: A series of transformations that map source to target
- starts with one or more source and terminates in one or more targets
- consists of at least one pipeline, but may have more
- Transformations: transform input to output
- Source Qualifier: read data from sources
- Expression: perform row level computations
- Filter
- Sorter
- Aggregator
- Joiner:
- homogeneous joins form with data/tables from the same database. Heterogeneous join between different source, eg: DB2 and Oracle
- Union:
- Lookup
- Router: routes row conditionally
- Passive Transformations: one output row for each input row
- Active Transformations: number of output rows do not match input rows
- Session: An object that runs a mapping
- Workflow: An ordered set of (DAG) of sessions and other tasks (such as send an email). A job
- starts with a Start task, and links to other types of tasks, including session task
- metadata repository: stores information about mappings, workflows, sources and targets
- uses Folders to organize
- Shortcut Folders point to shared folders for reusing components such as Source Qualifiers
- Ports: represent input and output field in a transformation
- A Variable port is a virtual or derived column from an expression
- Order of execution: Input and Input/Output -> Variable -> Output ports
- Source Analyzer: Designer tool to create source definitions
- A Shortcut, usually source or target definition, is a dynamic link to previously defined shared object