Star Schema vs All in one table
Hi, I have a scenario where we have dimensional information and the facts in one table rather than a traditional break up into facts and dimensions. What could be the problem i could run into with having all information in one table. Thanks.

INTERVAL TIME SUM COLUMN
Hello, In my data warehouse I have a fact table that joins with calendar table on BETWEEN clause ( calendar.date between myfact.startdate and myfact.enddate ). In calendar date I have a record for each day. I need to sum a fact table column in my

Separate column for moderator names
Now moderator names are displaying below forum forum names in this format: Forum name Moderator: Username I'm suggesting to add separate column on index page for moderator names, (like topic and post numbers or Last Post). This will abridge the

Location column back in the members list
Ok i have noticed a few members asking how to put the location column back in the members list.It seems the last update has changed that and removed it from the members list column.So i will start a thread to suggest the return of the location within the

Riflemen to the front of the column
This time they were not been sent off to act as forward scouts in territory they were sure of holding; this time their job of sweeping the area in front of the column was being done for real. Even the army would march without the formal parade first -

Trader Philosphy
Great advice we traders should follow before making a trade. I found this on a blog I often read oiltradersblog.blogspot.com. To quote Gordon Gecko, "Don't get emotional about stock.": Humans have weaknesses that hamper their trading

Dates in many dimensions
Hello, I am new to DW. Currently, I am working on a Human Resource database. There are many tables in the source systems which stores dates e.g. dates about contract start, finish, Vacations of an employee, temporary service suspension and many more.

Dimensional Modelling
In OLTP I have product table -- contains product information customerproduct table -- customer product info like when this customer bougth this product etc (custid, prodid is PK) customerprodsubprod table -- customer product sub product information

New User Extenstions regarding webtable testing.
Hi Guys, I have developed some new user extension to test web table which is not possible from basic commands. so, for you I have develop some and I'm sure this will help u guys to test your applications. Note: This user extension is workin

Type 2 dimension or type 2 column?
Hello, As a student and champion of the Kimball method within my organization, I get questions from time to time that require some research: My data modeling tool provides "dimensional" selections, including a tab where the user can designat

A dozen systems with many dimension codes
Hi, I have more than a dozen systems to integrate, and each has it's own version of dimension codes. The source systems need to use dummy codes, and multiple codes for one entity. This for operational reasons. So, to conform a dimension I have a

Indicator Dimension or Fact Table
Sorry, this is a long explanation but I wanted to document the entire “case”. Thanks in advance for your advice. Background: Currently we are modeling a data mart for traffic accident data. The source system is a repository rather than a

Partition Pruning issue
We're looking into partitioning one of our star schema fact tables on Campus Name. The fact table consists of students enrolled by Campus. We're using Oracle 11g. The DBA is saying that we need to add Campus Name to the fact table in order for partitio

dimension model for many indicators field
I have 30+ fileds that has either 1 or 0 ( true or false)value in a fact table Patid -- -- --- PTInd_1 Ptind_2 Ptind_3........ PTind_30 -- etc 1

fact table as a dimension
Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both