GLOSSARY logo

GLOSSARY

THE TECHNICAL LANGUAGE OF DIGITAL B2B INFRASTRUCTURE

PRACTICE
DATA ENGINEERING

Extract, Transform, Load (ETL)

A data-integration pattern in which data is retrieved from sources, transformed into the required structure, and then loaded into a target system.


BUSINESS RELEVANCE

ETL supports controlled, repeatable preparation of data for reporting, migration, compliance, and operational use, especially when the target should receive only curated data.


IMPLEMENTATION EXAMPLE

A nightly process extracts CRM and billing records, standardises account identifiers, validates currencies, calculates revenue fields, and loads approved tables into a warehouse.


LIMITATIONS

Pre-load transformation can increase latency and infrastructure complexity. Rigid pipelines may be difficult to adapt when source schemas or analytical needs change, and transformation errors can silently propagate without testing.


TECHNICAL EXPLANATION

Extraction collects source data; transformation validates, cleans, joins, standardises, and applies business rules; loading writes the prepared result to a warehouse or other destination. ETL often uses a separate processing layer before the target receives data.


Secondary Topics

Systems Architecture

Related terms

Sales Forecasting

PRACTICE
REVENUE OPERATIONS

The analytical practice of estimating future enterprise revenue through pipeline metrics, win rates, and market indicators.

Cross-Selling

PRACTICE
REVENUE OPERATIONS

A commercial practice offering related or complementary products to existing customers to expand basket size and order value.

Extract, Load, Transform (ELT)

PRACTICE
DATA ENGINEERING

A modern data engineering paradigm loading raw information directly into a target warehouse prior to model transformations.

Paid Social

PRACTICE
PERFORMANCE ADVERTISING

Sponsored advertising campaigns published across social media networks targeting granular user demographics and interests.

Multi-Factor Authentication (MFA)

PRACTICE
CYBERSECURITY

A cybersecurity access protocol requiring users to confirm identity via two or more distinct verification categories.