Adding a new Dimension to the Star-Schema

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:

Advantages Disadvantages of Star Vs. Snowflake in your DW Env. Has anyone switched from one to another & Why ?

Can anyone list the advantages and disadvantages of Star vs. Snowflake in your DW environement . And has anyone switched from one to another and why?

Flat Table vs star schema

We hear a lot of BI implementations using star schema. (with few dims snowflaked sometimes ) Why not choose a flat table with all data put together instead of a star schema? (well , this question may seem strange, but please help me out here) Few

star schema designing

Hi , Iam new one to datawarehousing.How to design the star schema. we have the hr module(OLTP) which has 77 tables. I have some basic doubts please anyone clear that. http://en.wikipedia.org/wiki/Star_schema For ex. I followed the above

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!

Tip #136 Adding a Mini-Dimension to a Bridge Table: What if you can't split the dimension?

Hi folks, I've just received the "Tip #136 Adding a Mini-Dimension to a Bridge Table" and despite I think it is a good idea for specific and isolated cases, I would like to know what would happen if customer dimension is conformed within the bus

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

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

Health Care Dimensional Modelling

Hi, I am working on Health care project to do data modeling to create either star or snow flake schema. Here is my table list Dimensions Tables: Patient, Provider, Medication, vaccination, procedure, observation, diagnosis and lab results(These are just

Your Temper According to Your Star Sign

ARIES .... MARCH 21 – APRIL 20 Nothing seems to ruffle you more than a lack of discipline, disloyalty and decorum. But Arians are also known to go into a rage very easily when challenged. Those of you who have been on the receiving end of the Aries

custom bbcode*

we should have the ability to post our own custom bbcode(this comes with phpbb3)

LOL PICS YES?

Yup..I donno...this just made me laugh today