Across
- 4. The level of detail captured in the data warehouse
- 5. A data structure associated with a table that is logically ordered by the values of a key and used to improve database performance and query access speed.
- 6. A fact table that has no facts but captures certain many-to-many relationships between the dimension keys.
- 9. Mandatory condition in a data warehouse where all the keys in the fact tables are legitimate foreign keys relative to the dimension tables.
- 10. A database designed to integrate data from multiple sources for additional operations on the data and then passed back to operational systems for further operations and to the data warehouse for reporting(acronym).
- 11. process of analysing and discovering patterns in large data sets.
- 12. A subset of datawarehouse which is usually oriented to a specific business area.
- 14. ___schema has normalized dimensions
- 15. In which type of slowly changing dimension (SCD) technique is a new column added to the dimension table to capture the change?
Down
- 1. A logical modeling technique that removes data redundancy by separating the data into many discrete entities, each of which becomes a table in a relational DBMS.
- 2. ______dimension is a convenient grouping of typically low-cardinality flags and indicators.
- 3. A secondary dimension table attached to a dimension table when a dimension is snowflaked.
- 7. non natural key
- 8. The number of unique values for a given column in a relational table.
- 13. ___indexes are used for high-cardinality fields.