How to handle multiple many-to-many dimensions in a single star sch...

Question on symmetry in Star schema

Hi I read Kimball's Data warehouse toolkit and I came across a point that one of the advantages of having star schema is - BI / reporting tools in the market can leverage the symmetrical nature of the star schema. From what I know and I could

Adding a new Dimension to the Star-Schema

Dear experts, Im currently handling with a for me not-solvable problem. I want to add/implement a new Dimension to my star-schema. The fact table is already connected throw surrogate keys to several dimensions. A few of the dimension tables are

makeing a stand for star schema design

Hi, I am new to a financial company and I was asked to model two new sources of data in the existing mortgage data mart (not too sure if you could actually call it a datamart after seeing the design), basically I was asked to create detail information

Fact 1:N Dimension with Star Schema

This seems like a very simple problem, but I can't seem to find the answer anywhere. I want to have a situation where a single fact record is associated with 0..N dimension records of a single dimension. An example would be: Fact Table:

City and Airport Terminal tables in dimensional modelling

Hi, We have City and Terminal as 2 separate reference tables around Order fact in Star Schema. Products like Hotels, restaurants are reported at city level and granularity for products like Flight is at terminal level. Both City and Terminal table

Template Star Schemas

All, Is there a website or a book that we can use that has Template Star Schemas (Starter Kits) for different industries. I already have Dr. Kimball's Data Warehouse toolkit book. Is there any other material (web or book) besides the one? Thanks!

FIVE STAR ALLIANCE HOTEL

HOTEL JOB VACANCIES FIVE STAR ALLIANCE HOTEL <fivestaralliancehotel@fivestaralliancehotel.com> Thu, Jan 12, 2012 at 1:06 PM Reply-To: services@fivestaralliancehotel.net I am Vicky Spore from Canada, Working with the Five Star Alliance Hotel

Cube Processing for Dimension Schema changes

Hi, I had a general question about how cube processing works. If my dimension schema changes (an addition of a property), will I have to do a full reprocess of all cube partitions for which that dimension was member of? Or do I only need to

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

How to manage Conformed dimensions

Hi, If I'm implementing data mart by data mart, I build a dimension for the first data mart. After a few months, I realize I can use that dimension for the second data mart as a conformed dimension. But it needs additional columns. How do you manage this

Blue Diva SR 500 project from Andreas

So guys - time to start a new topic - no mix with my Ducati. First picture show you the basic bought for 250,-, born in 1982 with 62000km under her feeds. Complet demontage. Frame goes with 1001 other parts for a special "candy blue" powder

Random Renderings

This is where I shall post random renderings I do in 3ds max. So, here's the JJ-Enterprise firin her phazorz!

One click! I return ALL votes SAME DAY! ends 31.aug.

Please vote for me to be bride of the year - this link takes you to my picture: http://brideoftheyear.bridetobe.com.au/vote.php?show=2018 (should say couples name : Jessie & Beau) how to vote.... 1) Enter link above in url 2) Enter the

How to handle multiple many-to-many dimensions in a single star schema