Hack Your Database Before the Hackers Do

May 1, 2008

Occasionally, there are miscellaneous attributes, such as yes/no attributes or comment attributes, that don’t fit into tight star schemas. Rather than discarding flag fields and yes/no attributes, place them in a junk dimension. In addition, you can handle comment and open-ended text attributes by creating a text-based junk dimension.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=98576