Tracking Type2 SCD when using a dimension outrigger

Tracking changes in a hierarchy

Hi, I'm working in a DW project on a bank. They don't like to much the use of subrrogate keys and they prefer to use natural keys. One of the problems we have is a product hierarchy. I'm going to simplify it. The hierarchy is something like: Categor

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

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

Combining Factless Facts and Bridges - sensible or not?

We are working in a MS SQL Server 2005 environment using SSIS to populate our DW DB and SSAS to build our OLAP database from that DW DB. It is not a huge database in the scheme of things - 28 million payments, 6 million customers, 2 million membership

Handling a SCD Type 2 change in a fact

Hi, I'm in the process of designing a dimensional model for a product warehouse, and a question I have is about how to handle a change of a Type 2 dimension in a related fact. I am keeping the details of each of our products in a Type 2 dimension (name

Require comprehensive test cases for SCD Type2

Hi, I have written the following code in Oracle for SCD Type2. SCD2 table name is employee_tgt and source table is employee_src. It maintains history of column emp_name. The primary key is emp_id and the surrogate key is emp_sk. The load is assumed to run

Anti-Tracking list possible for the Internet (Do-not-track)?

The Federal Trade Commission has heard you. On Wednesday, it turned up the heat on the technology industry – and browser makers specifically – to move more quickly to create simple, universal controls to let people tell advertisers and data brokers that

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

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

Supplier Dimension to include Customers & Employees

We are in the process of finalising Dimensions /Facts to be used in Datawarehouse. Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses. During designing Accounts Payable Fact

Date Dimension

Hi All, I understood Kimball way of implementation Date Dimension table. In a way, the lowest granularity date represent each record, with the following month, quarter and year attribute. However, what happen if the lowest grain of certain fact are at

Dimension loading sources

Hi all, It's about datawarehouse dimension loading : should i load dimension from a master data management referential or from the truth of my business application. In the first case, dimension will be cleaner than in the second case but it will not

Linking or Merging Similar dimensions from Different Source Systems

We've got a situation with the DW we're building where we have 2 seperate systems that we are wanting to bring the data together for cross analysis 1) The first system is the main operational system ie a contact management application that records