Modeling issue

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

Need help with modeling employee and degrees earned

Requirements: 1) Provide monthly employee counts that can be sliced by an employee's degree granting institution(s) and/or institutional research activity levels 2) Count new hires by their highest degree earned at time of hire and/or by terminal

Modeling goals which may slowly change over time

I did a quick search on goal modeling and didn't seem to find an existing scenario that matched the one I am posting about. I have a DW modeled against data from a time-charging application within an IT department (ie everyone must record time spent on

Issue with modelling a hierarchy so the OLAP cube build is efficent

I am faced with a nasty which seems to have no neat solution within dimensional modelling. (This could well be just me being brain dead and dumb). Background: We are a major commercial bakery company. Having re-developed and released the first two

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

Nexus S torn down by iFixit

Want to know what's inside a Nexus S? It's not peanut butter or creamy nougat, but it's almost as good. The folks over at iFixit put their screwdrivers on turbo mode and have the Nexus S in a few dozen pieces, here's some of what they found: *

Throttlegate: Dell covering up laptop issue

Dell may have a serious issue on its hands with their E6400 and E6500 laptops. Hundreds of reports have been surfacing on the official dell support forums stating that they have had "massive performance issues…whenever the devices get slightly war

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

Ask : Hot Legal Issues for seminar and Workshop

Dear lawyers, Mohon pencerahannya. kantor gw mau bikin seminar and workshop dibidang corporate and contract law, capital market, mining, banking, etc. Gw butuh inspirasi, ide dan masukan dari rekan-rekan sekalian kira-kira isu-isu hukum apa yang menuru

Interview with Guy in the new Issue of Q

Not sure if this is available yet, but there is an interview with Guy in the April issue of Q Guy Garvey With a mantelpiece groaning under the weight of their award haul, Q speaks to Elbow frontman Guy Garvey to track his progress from Kevin The

Inside the Coby Kyros 7015 & How to Replace the Battery

Inside the Coby Kyros 7015 Looks like a header for HDMI? Looks like we can do some mods