Schema: Store Channel w/ Dimensions
{"Image DocumentName": "Schema: Store Channel w/ Dimensions", "Image ImageDescription": "date. store_returns. reason. store. store_sales. item. customer. customer_ address. Promotion. customer_ demographics. household_ demographics. Static: The contents of the dimension are loaded once during database load and do not change over time. The date dimension is an example of a static dimension. Combination: The rows in this dimension are uniquely identified by a combination of all attributes of the dimension. The surrogate key may also be used to uniquely identify a row. Household demographics and Customer Demographics are examples of a combination dimension. Historical: The history of the changes made to the dimension data is maintained by having multiple rows for a single dimension value. Each of these rows has a start and end date associated with it indicating the time period for which the dimension attributes are valid. The fact data is linked to the dimension values that existed at the time the fact was recorded, thus maintaining historical truth . Item is an example of a historical dimension. Non-Historical: The history of the changes made to the dimension data is not maintained. As dimension rows are updated, the previous values are overwritten and this information is lost. All fact data is associated with the most current value of the dimension. Customer is an example of a Non-Historical dimension. income band.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}