Dimension Tables
Dimension tables store descriptive attributes that provide context to the facts.
| Dimension Table Name | Description | Indices |
|---|---|---|
| ccdw_dim_business_channel | Categorizes different business channels. | business_channel_id, business_type,order_channel |
| ccdw_dim_campaign | Describes various marketing campaigns. | campaign_id, ncampaign_id |
| ccdw_dim_coupon | Provides details about coupons. | coupon_id, ncoupon_id |
| ccdw_dim_currency | Provides details about various currencies. Each row represents an ISO 4217 currency. | currency_id, alpha_code |
| ccdw_dim_customer | Contains detailed information about customers. | customer_id, ncustomer_id |
| ccdw_dim_date | Contains various attributes related to dates, providing detailed temporal information. Each record represents a calendar date and its component parts (year, quarter, month, week, day). | day_id, day_timestamp, week_id, week_timestamp, month_id, month_timestamp, quarter_id, quarter_timestamp, year_id, year_timestamp, weekyear_id, weekyear_timestamp, year_of_era,month_of_year,day_of_month |
| ccdw_dim_geography | Provides geographical information, particularly for regions and countries. Each region rolls up to a country. | geography_id, iso3166_alpha_code, country_code |
| ccdw_dim_locale | Stores information about different locales, such as language and country settings. | locale_id, locale_code |
| ccdw_dim_location | Represents individual physical locations, likely for inventory or shipping. | location_id, nlocation_id |
| ccdw_dim_location_group | Groups physical locations together. | location_group_id, nlocation_group_id |
| ccdw_dim_payment_method | Lists available payment methods. | payment_method_id, npayment_method_id |
| ccdw_dim_product | Contains detailed information about products and SKUs. Each SKU rolls up to a product. | sku_id, nsku_id, product_id, nproduct_id |
| ccdw_dim_promotion | Describes various promotions. | promotion_id, npromotion_id |
| ccdw_dim_site | Stores information about different e-commerce sites or storefronts. | site_id, nsite_id,nrealm_id |
| ccdw_dim_source_code_group | Categorizes source code groups, often used for tracking marketing channels. | source_code_group_id, nsource_code_group_id |
| ccdw_dim_time | Contains various attributes related to time, providing detailed temporal information within a day. Each row represents a minute of a clock. | time_id, minute_of_day, hour_of_day |
| ccdw_dim_timezone | Contains information about different time zones. | timezone_id, ntimezone_id |
| ccdw_dim_user_agent | Stores details about user agents, which describe the client software making a request. | user_agent_id, nuser_agent_id, ua_family_code, ua_class_code, ua_family_vendor_code, crawler_category_code, os_family_code, os_family_vendor_code, device_class_code, device_brand_code |