MAR 7, 2008 1:09am ET

Related Links

Unstructured Data Offers Big Benefits
July 23, 2014
SLM Tools Moving To Monetization Models
July 23, 2014
Insurers Think Inside the (Black) Box
July 21, 2014

Web Seminars

How Intelligent Digital Self-Service with Customer Analytics Can Lower Costs and Raise Revenue
July 29, 2014
Improve Omni-channel Shopping Experience with Product Information Management
August 21, 2014

Apart from bloated dimension, what are the negatives of using all known attributes in your SCD?

Print
Reprints
Email

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.

Get access to this article and thousands more...

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!

Already Registered?

Filed under:

Advertisement

Comments (0)

Be the first to comment on this post using the section below.

Add Your Comments:
You must be registered to post a comment.
Not Registered?
You must be registered to post a comment. Click here to register.
Already registered? Log in here
Please note you must now log in with your email address and password.
Twitter
Facebook
LinkedIn
Login  |  My Account  |  White Papers  |  Web Seminars  |  Events |  Newsletters |  eBooks
FOLLOW US
Please note you must now log in with your email address and password.