For those of you that are doing one or more Data Warehouses/Data Marts/Operational Data Stores a few questions for now:
- Did you model your DW/DM/ODS?
- Do you tend to use the Bill Inmon or Ralph Kimbal architecture?
- Is your design truly dimensional (i.e., fact table/dimensions)? If not, what is your architecture?
- How many Terabytes is your DW/DM/ODS, not your raw data, your DW/DM/ODS?
- If dimensional, roughly now many rows in your fact and dimension tables?
- Do you use surrogate keys? If so, how did you come up with your key structure? If not, why not?
- Are you using an ETL tool or build it yourself? If the former, which one?
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.