ETL / ELT Solution
ETL
- Extract
- Transform
- Load
ETL plays a vital part in moving data across. Many ways ETL can be implemented.
Popular ones
GUI Tools such as
- SSIS
- Pentaho
- Talend
- Scripting Tools such as Bash, Python.
ELT
- Extract
- Load
- Transform
In big data platforms such as Hadoop, and Spark, you can load a JSON, or CSV file and start using them as is. This technology can even parse compressed .gz / .bz2 files
Extensively used when dealing with Semi-Structured databases.