Large number of snowflake code tables per dimension
Ten(10) or so key dimensions(lets call them base dimensions) each has about 25 parent code tables in the 3rd normal operational source. Each code has a short and long description. In the multidimensional model If a fact table has say 3 base dimensions the

Best Practices for SCD Dimension Tables for a Banking Data Warehouse
Hello, I am looking for a list of dimension tables to track historical changes on for a banking data warehouse, based on "best practices". Customer is a prime candidate. Are there others? Thanks, Ike

Architecture questions : implement historical data view without SCD?
Hello ! I need some fresh points of view of an architecture I’ve just encountered. This solution was designed by a consulting firm specialized in the HR IT field. The DWH in this case is supposed to handle 100’000 employees for an organization of

Dimensional table design dilemma, Aditional column or Xref table
Here is my situation. We have a currency dimension table which stores the ISO currency codes (e.g. USD for US Dollar) and a surrogate key, currency description along with some maintenance columns (insert date, update date etc..). We are trying to

Staging > ODS > EDW
I have a basic query on Staging > ODS > EDW architecture. how the incremental data would be populated in EDW? Assume i have a "Customer Addess" Staging table which selects the delta from source system, then it updates the "Custome

Multi valued dimension attributes, weighting factor and cognos
Hi, we have several attributes in our product and customer dimension which might by multi valued. We modelled these as multi valued dimension attributes using bridge tables and weighting factors therein. Can anybody reference a best practice

Partitioning Strategy for Fact and Dims in Oracle/DB2/Sybase
Please specify the partition strategy you follow in your organization for facts and dims in Ora/Sybase/Db2 Thanks, bi_at_nj

Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
I'm working on a new warehouse application for reporting against our IT Project database. I want to create both a transaction fact table and an accumulating snapshot fact table. The project database (source) consists of multiple normalized tables to

Type 3 Slowly Changing Dimension
I am trying to find a best example / scenario where a type 3 scd would make more sense than a type 2. In my understanding type 3 can easily be derived from type 2. If anybody has used type 3 dimension instead of type 2, please let me know the scenario an

Historical and Incremental Loading of Dimension and Fact tables
Hello I have been reading three of the Kimball books and playing with the MDWT_AdventureWorks_SSIS sample. I have learnt a lot but I have also become overwhelmed as I was new to DW/BI up until a few weeks ago. Also, the books are very detailed and ther

Real time datawarehousing
Hey, There is a lot of buzz going on regarding real time datawarehousing. But how do you actually do this ? How can you implement conformed dimensions and conformed facts in real time ? How can you consolidate data real time ? Vendors promise

How to load a Slowly Changing Dimension Type 2 with one SQL Merge statement in Oracle
This is based on Design Tip 107 ("Using the SQL MERGE Statement for Slowly Changing Dimension Processing") and does sth. similar in Oracle You can access the solution at http://www.business-intelligence-quotient.com/?p=66