Sorry, but there are no more tags available to filter with.
-
If you populate the Date dimension on demand ... 1. Do you only put records in the date dimension for which there is an associated record in the fact table(s) it touches? 2. How do you handle columns like 'Holiday Indicator', etc... which seem difficult to simply script out?
-
Hi Teo, In my survey data warehouse I store data for a variety of different surveys. The dimensions are conformed more or less accross all surveys ... but I have had to create an extra junk dimension for a few that are specific to them. What is the best ... or best options design wise? So far, for every...
-
Ok ... I'm putting together a date dimension following the suggested schema proposed by Kimball in his DW Toolkit book on pp.38-41. But how to populate it? Is there a SQL script out there already in the form of a stored proc or UDF which can do this given a begin and end date as parameters??? Just curious...
-
Hi Teo, I have a data warehouse used to store data from a variety of different surveys. One of these surveys includes several demographic questions (e.g. gender, ethnicity, sexual orientation). Analysts want to slice and dice other questions by the answers users give to these demographic questions. So...
Page 1 of 1 (4 items)