Tuesday, August 31, 2004

"As Is" vs "As Was" Reporting Using Type 2 Dimensions

Mark Rittman has a real good writeup on some dimension modeling scenarios, which are always nice to keep in your toolbox.

Reminds me a little of the classic HR Schema (explained by Ralph Kimball), where the Employee Dimension has as many rows as the Fact table, with the benefit of knowing exactly how theings looked at any point in time in the past.

16 Comments:

At 5:30 PM, Blogger mia said...

I give your blog an A+ with a Gold Star! I really enjoy your content and will be back very frequently! I enjoyed the information you had on business intelligence as well. I actually have an business intelligence blog with all kinds of cool things in it. May I put a link to this blog of yours on mine?

 
At 11:28 PM, Anonymous Anonymous said...

This blog is awesome! If you get a chance you may want to visit this inventory management software site, it's pretty awesome too!

 
At 2:05 AM, Anonymous Anonymous said...

I found a new submit article to magazine. Post your Articles, Get Free Content. submit article to magazine

 
At 4:51 PM, Blogger upriser resources said...

You must get a lot of traffic with a blog this nice! I'll be back for sure. Hey, look at my site over here: handheld instant messaging device. As you can tell, it has to do with handheld instant messaging device! I trust your judgment. What do you think?

 
At 9:46 PM, Blogger tweedledeetweedledum said...

This blog is awesome! If you get a chance you may want to visit this download site myspace.com site, it's pretty awesome too!

 
At 8:13 AM, Blogger Steve Austin said...

Informative blog. I have a xhtml css editor blog.

 
At 4:44 PM, Blogger harvir said...

Hi i am totally blown away with the blogs people have created its so much fun to read alot of good info and you have also one of the best blogs !! Have some time check my link to !!Financial freedom realty services

 
At 5:52 AM, Blogger Jason said...

Hi there, Nice little blog you've got going on there. Keep it up! This might interest you if you're after some increase web traffic The contents of this site will explode your increase web traffic

 
At 7:33 AM, Blogger WorldTrader said...

Great Blog, check out this business. This is the Goose that lays you Golden Eggs! business business home home make make money money online online successforfreedom.com
Submit your Articles and get lot of backlinks: http://articles.for-your-website.com/
-----------------------------------------------------------------------------------------------------------------

 
At 12:20 PM, Blogger Leonard Payne said...

It's been really great looking and reading your Blog. Any fresh ideas on targeted internet marketing are always welcome to folk like me. You may also be interested in some incredible software that I've seen that really helps in the area of targeted internet marketing.
It can drive thousands of targeted links back to your website or Blog. Well worth looking at.

 
At 2:23 PM, Blogger Cyber Financial Corporation said...

Hi,

I liked your blog. I found many interesting information here.
I also give free info about affiliate marketing. You can seen it on my affiliate marketing site.

If you have time please visit my web site to get some free affiliate marketing information.

Kind regards,
Nick

 
At 5:21 PM, Anonymous Anonymous said...

To do your marketing for your business you can Marketing with the ebook at Marketing Go and check it out.

 
At 6:53 PM, Anonymous Anonymous said...

Good Posts, Keep on Blogging.
Be sure to visit

Advanced Business Marketing

Expensive Marketing Secrets Free.

 
At 4:53 AM, Anonymous Anonymous said...

Thanks for the info, I added you to my favorites.
If you are interested in home based business insurance
, I have a home based business insurance
site.
Feel free to drop by and tell me what you think.

 
At 5:36 AM, Anonymous Anonymous said...

Hey, you have a great blog here! I'm really enjoying business

I have a internet mortgage lead business site/blog. It pretty much covers internet mortgage lead business related stuff.

 
At 5:44 AM, Blogger Kenneth said...

based business home idea service

 

Post a Comment

Links to this post:

Create a Link

<< Home