Dimensional models for K-12 education
Hello everyone, As a DBA I'm just starting out in the data warehousing field and I'm having difficulty locating dimensional model examples for education. The examples that I have come across pertain to sales, manufacturing, billing, etc and I'm looking

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,

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

Complex Inventory Model
I am designing an inventory model with dimensions: Product, Location, Time, and Collection Type. The relationships here are: 1. A Location is assigned Items that they can only have in stock 2. A Collection is assigned Items. 3. A Location is assigne

Controlling the amount of space a user has to upload files.
Is there a way to control the maximum amount of space that members can take up with their attached files? For example, if my forum has 1000 Mb, would I be able to set it so that members can upload no more than 250Mb of files? I am not talking about the

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

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

SET2/Q.3 Given below are the patterns of three individuals, explaining how they interact socially.
Q.3 Given below are the patterns of three individuals, explaining how they interact socially. Miss Sunidhi- She is protective and controlling Mr Rajat-He is rational ,calculating and unemotional. Mr. Sahil- He is spontaneous and dependent. Classify

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,

Controlling Your Dreams (Lucid Dreaming)
I thought this was interesting when I first found it a while ago, so I figured I'd share it with you guys. http://www.ld4all.com/

Updated Firmware Version 2.1.3 1/27/11
Archos has given a new update for the Archos Generation 8 tablets. Version 2.1.3 - January 27th, 2010 * Video: fix some audio glitches after seeking WMA files * Video: add support for MTS files * Video: bring UTF-8 and UTF-16 encoded

New Style [BETA VERSION] - VOTE HERE!
Hey guys! As you can see, I decided to change the Style of our forum. However, I am not really satisfied with it yet. So This is only the BETA Version. It would be awesome if you can help me with your opinions and vote for your favourite option! Any

how to know version of kernel and android source code
I have downloaded the 2 latest files odroid-c110.kernel.tar.gz odroid-c110.android.tar.gz how to know kernel version ? how to know android version (e.g. how to be sure that this is froyo/2.2)?

Data Warehouse for survey data
Hi All, Working with a company which uses Salesforce.com heavily. They have a large number of custom fields, and great volatility in them - frequently adding and deleting them when they cease being relevant (They collect survey data for their clients).