Data Lineage: Transformation Tracking
ETL Transformation Lineage
Tracks how individual fields flow from source systems through ETL transformations (Informatica PowerCenter) into target staging tables. Two source fields (Firstname, Lastname) are concatenated into a single Fullname target field, while Lastname passes through unchanged.
Node Types
| Colour | Type | Role |
|---|---|---|
| Dark navy | System | Source/target/ETL servers |
| Mid navy | Service | Database or ETL service instances |
| Slate blue | Database | Named database schemas |
| Teal | Table | Source and target tables |
| Teal (darker) | Field | Individual columns |
| Amber | Transformation | Field-level transform logic (e.g. CONCAT) |
| Amber (darker) | Workflow / Mapping | ETL orchestration artefacts |
| Gray | Source / Target | Lineage anchors connecting fields to transforms |
Relationships
- READS — mapping reads from a source connector
- Unlabelled edges trace the structural hierarchy (
System → Service → Database → Table → Field) and the transformation chain (Field → Source → Transformation → Target → Field)