Standardization vsTransformation
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. In a Data Warehouse, what is normally kept in the Landing Zone?
2. What do the tables in the Landing and Staging zones preserve from the source systems?
3. Which of these is an example of data standardisation?
4. What is data transformation about in the data world?
5. Which value is suggested for empty date rows during data standardisation?
6. Why does data standardisation suggest converting a string field that only contains numbers into a numeric type?
7. Between which zones does data transformation consume huge compute power?
8. By how much can compute power for data transformation be reduced if data standardisation is done first?
9. Which of the following is NOT a data standardisation scenario?
10. Why does serving always supersede processing as the reason for data transformation?