Dimension Table Indexing Strategy

Fact Table Indexing Strategy

Please explain the indexing strategy which is in use in your organisation for fact tables in your current database(oracle, sybase, db2) Specify volume as the indexing strategy may be based upon the volume of data. Is there a well laid out strategy

time dimension

Hi I have to create a time dimension to cater to the reporting needs. With the current database structure which is not a dimensional model we need to create reports that are period based. How do we create a time dimension table (we need year, quarter,

Data Warehouse - Indexes

Hi, I am currently at the point where I need to think about Indexes on my data warehouse. We are currently using SQL Server 2005. As a general rule of thumb would the following hold true (Please note that the reporting requirements are still

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

Indexing option on numeric fact referred to in DW Toolkit 2nd edition

In the 2nd edition of THE DATA WAREHOUSE TOOLKIT, Chapter 9, page 208 at the end of the first paragraph, there is a reference to an indexing option on a numeric fact pioneered by SYBASE IQ product which has become a standard indexing option in competing

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

ECON303 Managerial Economics and Business Strategy 6th edition for sale $35

ECON303 Managerial Economics and Business Strategy 6th Edition by Baye ISBN-13: 978-0-07-3375687 $35 obo Contact me via either email (jangj@vcu.edu) or cell (8.0.4. 662-0163)

Econ 303 MANAGERIAL ECON.+BUS.STRATEGY BAYE $50 obo

Econ 303 MANAGERIAL ECON.+BUS.STRATEGY BAYE

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

Bridge tables versus massive junk dimensions

I am designing a star schema to store information on hospital stays. This is my first real star schema and things are off to a good start. My fact table is hospital stays. I have a diagnosis dimension. There are multiple diagnoses per stay. Costs are

Regarding Factless Fact Tables

Some time ago I was asked to build the BI platform for a road safety organization. The warehouse was built of three primary fact tables, each with a collection of associated dimensions. I am now trying to branch out into ETL and Warehouse design, and from

World PvP Event: Undercity raid strategy!

The Spanking Phoenixes proudly present: Undercity Raid! This raid is meant to be fun for everyone (lvl70), be you PvE'er, n00b PvP'er or Wtfpwning Imba PvP'er! The goal is to kill Dark Lady Sylvanas Windrunner of Undercity! The journey