Dimensional table design dilemma, Aditional column or Xref table

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.

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

Confusion - star, snowflake, bridge table

Appreciate your expert comment on following: Entities: Quote, Trade, DIRequest, Order User, Customer, Trader, Sales or Marketer and Product - User is a user who is using the system or interfacing with the system. i.e. requesting quote or placing a

Guidelines for FACT Table Design for High-Transaction Volume and High # of Measures ...

Hi All - This inquiry could actually be two questions, but the requirement is really presentation of row-wise high volume transactional data in a column-wise (columnar) FACT table. Here is a sample transactional data set: Interval Date TimeUni

Bridge table for INSURANCE

HI, I am creating the Property & casualty Insurance DW for Autopolicy I have PolicyTransactionFact, DIM_covered_item_vehicle, Policyholder_dim these are FK's in the fact table. and I created driver dimension table which has driver

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

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

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

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise

wEdETykE Design

In ordinea in care le-am creat: 1. 2. 3. 4. 5. 6. 7. 8. Acestea sunt unele dintre creatiile mele.

Green CoW's Gallery

Hi there...Here's some stuff I've done. Most of them are fulfilled requests. (just showing off the stuff I already had uploaded) Hopefully you'll find something nice! GC's Resource Packs Shooter ImageSet (.CFG file not included) A free imagese