Handling History tables in Dimensional Model
Gurus, We are designing dimensional model for our organization. In our current OLTP system we have base tables and history tables. The table structure of history tables is mirror of base tables with addition of 3 auditing columns (Transaction Type,

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

Iraq : UN calls for more financial resources to support education in Iraq
Iraq : UN calls for more financial resources to support education in Iraq (This Article Headlined 21/4/10) BAGHDAD - morning The United Nations called for more spending and provide additional sources of funding to provide education for all in Iraq. I

The Indonesian International Education Foundation (IIEF)
The Indonesian International education Foundation (IIEF) is an educational organization in Indonesia in cooperation with the Institute of International Education (IIE). IIE is the largest and most experience non-profit private educational exchange

Prime Minister Nuri Kamal al-Maliki chairing a meeting of the Higher Committee for the development of education in Iraq
Prime Minister Nuri Kamal al-Maliki chairing a meeting of the Higher Committee for the development of education in Iraq Chaired by Prime Minister Nuri Kamal al-Maliki at his office today, the official meeting of the committee for the development of

Schema Roadblock: Dimension vs Fact [Dimensions w/FKs to other Dimensions?]
Hello, I'm new to DM, I've picked up Kimball's DW Toolkit and DW ETL Toolkit - both great books. I'm designing a simple datawarehouse for eduction (K-12) and ran into a modeling question. I'm designing the portion pertaining to [homework]

SET1/Q.1 What are the types of Information Computing models?
Q.1 What are the types of Information Computing models?

Employee Hierarchy Dimension Table
Hello All, I am trying to model a Hierarchical Table, I need some help on what is the best way to model this scenario I want to Flatten the Hierarchy Horizontally in the Dimension Table, I want to keep it as a SCD Type 1 Overwrite information The

Understanding Materialized Views as aggregate tables
Hello I have to provide a count and I am using a materialized view in sql 2008 as an aggregate table. My issue is understanding how the count will work. I need a count by 3 different categories (Product, Type, and TypeName). So....should that field be

Data mart design
Lets say I need to model Frauds. There is 2 departments handle different Frauds say (Contract and Health care). I am going to model this in MD (fact, dimension). Now should I just create one Fact table(Business Process) and use say Fraud type (Contract,

no one seems to understand
there are plenty of people who have been into hardcore for a while, and will continue to be a part of it for a while the only kids who were really making want to write that rant were the kids who got into hardcore about 10 months ago, and act like its

Dimensional Gorge Thurs 19, 7pm est
Hi~ i'm trying to set up an item hunting party in dimensional gorge~~ The hunting party will last about 1 to 2 hrs. Gum will be provided to main killer! 1) Level Range: This is not a leveling party. So as long as u dont mind dying and possibly not

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

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

Different dimensional attributes in different 'dimension-like' source tables
This is a simplified version of the modeling issue that I am facing. Looking to the experts for advice. The product dimension has three attributes- sku, color and weight. Each attribute is stored in its own table with its own transaction date and