Dimensional modeling on HospitalStay

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

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

Schemas ... in the final dimensional models (BI database)

Hi quick question ... We are planning to have 2 or three staging databases. 1) Staging 2) Conforming and then finally the actuall BI database 3) DataWarehouse My question, in this final final database (3) should we use schemas to 'group

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

Geospatial Modeling

Are there any resources I can reference for modeling geospatial data? In our particular case, we are modeling a pipeline as the basic "fact" where the geographic location is of particular importance. In addition we need to model the location

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise

Model Iklan

Yang tinggal di lembah Klang sahaja..... Saya memerlukan model iklan berumur dari 2 thn hingga 60 tahun untuk iklan TV. Rupa dan bangsa tak penting, yang penting anda smua berbakat dan ingin cabaran. Kenapa saya kata "Yang tinggal lembah Klang shj"

CB 550 Caferacer "Betty"

Hi, unfortunately I found this forum not before today, so I just copy and paste the content of my already posted posts on my blog. It would be too much work to retype it, so please excuse this. The whole build is documented on my blog, too: