Dimensional modeling for operational systems

Can Data Warehouse be used as source for operational system

What are the pros and cons of using Data Warehouse (DWH) as source for an operational system? Background:- I work for a company who have now opted to use DWH to populate some of the small operational system's data base, The data in the DWH is

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

Operational Reporting

Hello Everyone, We have a Data Warehouse built on Kimabll Architecture(Business Process and Grain Driven). Which is working fine and serving the purpose for Performance Management and Analytical Reporting. All data comes from a home grown source system

Operational Reporting from a Dimensional Model

Having worked with various models over the years, i'm begining to think that a multi layered data model approach is best for medium and larger corporations. (see my IM model here

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

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

Real time datawarehouse replacing operational reporting

Hi, As I was reading through articles I came across one of the advantages in real time datawarehouse that it can replace the operational reporting so there is no need for reports to go across 2 reporting DB there can be one centralised Real time DW and

Dimensional Model Vs Views as Structure for BOBJ Universe

I have a fairly complex data mart (multiple fact tables: 5 at the moment and several more coming; 4 shared dimensions across the 5 facts, 26 total dimensions and several bridge tables). I used standard best practices for building the Business Objects

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

Data Vault v's Dimensional Model

Seems to be a lot of interest over at LinkedIn around the DataVault model. I wondered what the thoughts were about it. When would you use it v's a Dimensional Model or even a 3NF for a data warehouse. more info here:

Normalization in DWH environment

Hi All, Recently I came across a question,would like to post it here for the views of the members. What normalization form are the Fact and dimension tables and why (with examples aligning to the Normalization definition) Thanks, Dheeraj

Linking or Merging Similar dimensions from Different Source Systems

We've got a situation with the DW we're building where we have 2 seperate systems that we are wanting to bring the data together for cross analysis 1) The first system is the main operational system ie a contact management application that records