Migration to Dimensional Modeling - Testing

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

DIFFERENCE between Dimensional Modeling and Cube ?

Isnt cube part of Dimensional Modeling (Facts and Dimensions) ?

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

Normalized Data Store + Dimensional Modeling

Hi there Kimball forum, and welcome to my first topic :-), I just received my "Kimball's Data warehouse Toolkit Classics" on monday. Unfortunately I still can not find the hint, how to solve my design problem. We have a bit overcomplicated database

Dimensional model

Hey All In a Star schema, can a Fact table in one data mart be a Dimensional table in another data mart or can we connect two fact tables or what can we do if we need to connect a column (primary key) from one fact table to another fact table? Thank

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

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

PADM 691 The Migration Reader Exploring Politics and Policies

The Migration Reader Exploring Politics and Policies By Anthony M. Messina and Gallya Lahav This book is being sold used for $24.40 at the Monroe campus bookstore. I am selling it for $15. If interested please call me at 571-247-1746. My name is

Big Data - Big Math and Enabling Customer Intimacy at Scale

Engagement Leader Job Opening If building and growing an early stage company is in your career plan... If you bring a comprehensive leadership and management playbook for how to deliver large-scale data-intensive solutions If you have an excellent

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

Difference between a Cube and a Star

Hello, I have a very basic question. Can anyone please, explain the difference between a cube and a star schema? I studied about Star schema. When I implement it in Oracle Warehouse Builder 11g, I have to create a cube. Am I doing right? regards,

Date Dimension

Hi All, I understood Kimball way of implementation Date Dimension table. In a way, the lowest granularity date represent each record, with the following month, quarter and year attribute. However, what happen if the lowest grain of certain fact are at

New user extension regarding tooltip and image verification.

Hi Guys, Good news for you. I have developed some more functions in extenstion for tooltip and image verification which is not possible to do with relgular selenium command. This user extension is developed to provide extra functionality to users