Question: Apart from bloated dimension, what are the negatives of using all known attributes in your slowly changing dimensions (SCD)?
Chuck Kelley’s Answer: The amount of time that it takes to process all the rows. If it makes you feel any better, I generally use SCD for all attributes in all dimensions.
Chuck Kelley is an internationally known expert in database and data warehousing technology. He has 30 years of experience in designing and implementing operational/production systems and data warehouses. Kelley has worked in some facet of the design and implementation phase of more than 50 data warehouses and data marts. He also teaches seminars, co-authored four books on data warehousing and has been published in many trade magazines on database technology, data warehousing and enterprise data strategies. He can be contacted at chuckkelley@usa.net.
Be the first to comment on this post using the section below.