Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ETL and type 2 slowly changing dimension
Hello, I am in the process of setting up a datawarehouse for a distributed measurement system. The measurement probes periodically report measurement data (facts) which is automatically ETL'ed into the datawarehouse. One of the dimension tables is a type 2 SCD with the probe configuration...- optimax
- Thread
- Replies: 1
- Forum: Data Warehousing/Big Data
-
Wide fact table vs. multiple fact tables
Thank you all for the great comments! After discussing the issue thoroughly with my client, it appears that the 'unexpected' queries might not be so infrequent after all (thus probably calling for the wide fact table option). It seems that the flexibility is really a key factor to them, and they...- optimax
- Post #9
- Forum: Data Warehousing/Big Data
-
Wide fact table vs. multiple fact tables
Well, these are clearly 100+ different measures (and most of them are already groupings of an original set of 1000+ 'raw' counters). These telecom network elements are quite complex and thus require a fair amount of indicators. This is inherent to most complex radio transmission systems. From a...- optimax
- Post #3
- Forum: Data Warehousing/Big Data
-
Wide fact table vs. multiple fact tables
I am currently developing a data warehouse for a telecom company. We collect several different measures (100+) from the network elements on an hourly basis. I'm wondering what the optimal data warehouse design would be: 1) Since all measures bear the same granularity (1 hour), and originate from...- optimax
- Thread
- Replies: 8
- Forum: Data Warehousing/Big Data
