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.
Powered by Roadkill Wiki (2.0.275). This theme contains portions of its design from Mediawiki.org.