Data Transformation(ETL, ELT and ECL)
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What does ECL stand for in data transformation?
2. In ETL processing, where do the Extract, Transform and Load operations run?
3. In ELT processing, how many of the six operations run on the target system?
4. What is the first step of ELT processing?
5. Which operation is described as the most resource-hungry in ETL or ELT processing?
6. In which field is ECL processing mainly used?
7. Which of the following is NOT within the scope of ECL processing?
8. Which tool vendors will always suggest having a Landing Area in the target system?
9. How is Data Transformation described in relation to ETL developers and KPIs?
10. Which sequence of operations technically describes ELT processing?