Which statement is true about the ELT and ETL process?
- In the ETL process, the extract step occurs after the load step.
- In the ETL process, the load step occurs before the transform step.
- In the ELT process, the transform step occurs on the stored data as it is used.
- In the ELT process, the load step occurs after the transform step.
| Explanation & Hint:
In the ETL process (Extract, Transform and Load), data is first extracted, then transformed and then loaded into the database. In the ELT process ((Extract, Load and Transform) the load and transform steps are reversed. ELT enables raw data to skip the transformation step and go straight to storage in an unstructured form. Transformation then occurs on the stored data as it is used. |