Good dimensional Modeling web sites / books

Migration to Dimensional Modeling - Testing

Hello, I migrated a relational database to dimensional modeling database. I need to test that all the information in the source system is there in the target system. One technique which can be used is... - to calculate the number of records in the

Modeling help on dimension with many boolean value

Hi I'm really stuck on how to model a user need/business need Basically, we are in the healthcare and we have a software that manage the work of the paramedics in ambulances. There is a table that store all standard informations about the work of

Dating sites... Are they good? Bad? Anyone with any experience please post...

Hi... Okay this is not for me--- but one of my good friends (my son's age) is looking for the right girl, and can't seem to find her. He is nice looking, has a job, is a Christian, is personable, but he just hasn't found anyone. I suggested a

Advantages of Dimensional Modeling

Hi I have few questions on advantages of dimensional modeling as provided in the book DWH Lifecycle Toolkit by Ralph. (1) In the book , on Page 150, it is mentioned that "Aggregation software packages and utilities depend on a very specific single

Need for a dimensional modeling tool?

I'd like to hear opinions from members of this group about the need for a modeling tool that's more oriented towards dimensional models. Most of us use Erwin or a similar modeling tool, which is designed for general E/R modeling (to be honest, Erwin also

Dimensional modeling on HospitalStay

a different question on The Data Warehouse Toolkit, 2nd Ed. The complete guide to Dimensional Modeling. In Chapter 13 page 265 "In a hospital stay situation, however, the diagnosis group probably should be unique to the patient because it is

SAPBW and Dimensional Modeling

Ive been doing BI in SQL Server for about 5 years having started out reading Kimball Methodology. Our small company was bought by a larger company that is an SAP shop. What is the prevailing thought on dimensional modeling in SAPBW? Will I need to

Dimensional modeling spreadsheet license clarification

I've been using some of the tools provided with the "Microsoft Data Warehouse" book: http://www.kimballgroup.com/html/booksMDWTtools.html In particular the Dimensional modeling spreadsheet (under Chapter 2) and the Metadata database create

Dimensional Modeling-Checklist

Is there any checklist available for Dimensional Model?

2 sources using Dimensional Modeling Workbook

We are using Kimballs Generic Dimensional Modeling Workbook and it is really great! But now we have 2 sources to the same target and are not sure about how to document that. Anyone now about a best practice for how to document this in the Generic

alma mater (college ito!!!) malay mo, school mates pala tau!!!

hello guys and girls! let's talk about college life... your school, your course.. kahit wag ng batch... you may also add your most unforgettable, most embarrassing, happiest, loneliest at kung ano ano pang superlatives

bee sting

before someone goes and posts there messed up version of this here is the article. http://www.mlive.com/news/flint/index.ssf/2012/04/burton_police_arrest_michigan.html just in case anyone is wondering, i'm holding out until i hear bee's side of

Red Squad Discussion

Got any comments or questions pertaining to Red Squad, post here!