e
q
u
e
s
t
a
d
e
m
o < back
Webinar: ETL Patterns
{TOC}
ETL Patterns
TEXTETL vs ELT - these two methods are not in contradiction, rather they have different use cases.
ETL stands for Extract-Transfer-Load and is used when the transform better be performed on a fly. Indications are absence of environments, need to scale in transit, need to transform or mask in transit.
ELT is a pattern used when the real-time is not a requirement, processors and memory in transit are scarce, and there is plenty of additional hard drive. This is often a preferred migration method or data masking on the golden copy method.
Sometimes mixed techniques are used.