Question: Apart from bloated dimension, what are the negatives of using all known attributes in your slowly changing dimensions (SCD)?
Chuck Kelleys 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.
All Information Management articles are archived after 7 days. REGISTER NOW for unlimited access to all recently archived articles, as well as thousands of searchable stories. Registered Members also gain access to:
- Full access to information-management.com including all searchable archived content
- Exclusive E-Newsletters delivering the latest headlines to your inbox
- Access to White Papers, Web Seminars, and Blog Discussions
- Discounts to upcoming conferences & events
- Uninterrupted access to all sponsored content, and MORE!