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.