null values best practice digest

bmoraillon at 17h17
30
Aug
2010
null values best practice digest

Hi all,
i read all the post and design tips about null values management.
Can you tell m if the following statements are right or wrong for you :

Dimension attributes null values management :

For string dimension attributes, use :
"Not available" : if they're are not in the production system
"Not applicable" : if there is no sense


Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Null values in facts, yes or no?
Dear all, I'm wondering if anyone could help me out with the following (simplified) case. This is for my Business Intelligence study on a Dutch university where we do a project to apply BI to the student information systems, especially their results an
NULL Values in Fact Table
In an Accumulating Snapshot that has multiple dates, where we are revisiting the fact rows as additional events occur, should the foreign keys to the date dimension for dates that have not yet occurred be set to NULL or should they point to a
How to manage nulls in Fact talble
Hello, I am new with data warehousing. I need some help with following questions 1. should the nulls be left as nulls in fact table or should they be replaced with some number that might never be used like -7 or -1. If they should be replced with -1/-
SCD type 2 - Valid To Date Value? 12/31/9999 or Null?
Hello all, While populating Effective End Date (Valid to date) for current record, is it better to put a largest possible end date value of 12/31/9999, or is it better to insert a null value. One advantage of inserting 12/31/9999 as end date is that
Measures as Dimensions: Banding Approach Help
I have a standard fact table with a number measures; several of which are in the form of time (e.g., minutes) and others in the form of integers. The fact table and related dimensions are exposed to users via BusinessObjects XI v2 Web Intelligence. One of
Forums from same category
See also
more_less
Informations

1 Replies For the topic :
"null values best practice digest"

This topic has been viewed 1728 times.

Last message :
30/08/2010 at 17h17 by "bmoraillon"