Comments on I SQL: Best practice for slowly changing Fact tables.

tag:blogger.com,1999:blog-2264221406867865968.post9098015874268553414..comments2009-07-08T08:34:43.078+10:00Comments on I SQL: Best practice for slowly changing Fact tables.Leigh Kennedyhttp://www.blogger.com/profile/08681951093176503130noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2264221406867865968.post-32072816532474691572009-07-08T08:34:43.078+10:002009-07-08T08:34:43.078+10:00As far as I can see this just moves complexity dow...As far as I can see this just moves complexity down stream. Given the whole point of the Star Schema is to provide a simply and clear model for querying, I don't see this as beneficial to the overall solution.Leigh Kennedyhttp://www.blogger.com/profile/08681951093176503130noreply@blogger.com

tag:blogger.com,1999:blog-2264221406867865968.post-22235536381774147682009-07-07T17:08:47.183+10:002009-07-07T17:08:47.183+10:00How about creating a factless fact table? Take a l...How about creating a factless fact table? Take a look at another blog by Andrew Fryer http://blogs.technet.com/andrew/archive/2009/03/03/changing-dimensions-fast-or-slow.aspxInnovatorhttp://www.blogger.com/profile/11765142655817482764noreply@blogger.com