Advanced Topics of Dimensional Modeling
Because of the various levels of hierarchy, data in a dimension table in Star
schema contain duplicates or redundant values. Thus dimension tables are
not typically normalized. There is no redundanc
A reasonable predetermined number of possible values for the Plafond Details dimension table are about 100,000 records. In that way we can have 5 attributes and 10
possible combinations. If we need more than 5 attributes the best option is to create
Note: Closed books and notes. 80 minutes. Dont be late!
Type of questions
Concepts/knowledge: short answers and essays, some of which using examples.
Give definitions and examples of data, information and knowledge
Data Warehouse Design for E-Commerce Environment
Il-Yeol Song and Kelly LeVan-Shultz
College of Information Science and Technology
Philadelphia, PA 19104
Data warehousing and electronic-commerce are t