Best Practices for SCD Dimension Tables for a Banking Data Warehous...

Banking Data Warehouse

Hi, I want to build a Enterprize Banking Data Model. So I want to know the basic conformed dimensions for the different subject areas of Loan Application, Payments, Customer contacts, Account Balances. Can you provide me with any documents or a standard

Dimension Tables as lookup tables

Recently one of the developers at my organization approached me and asked that I take a table that exists in one of our source systems and put it in the DW, so that he could populate a drop down and validate data for the web app he was developing. ie,

Building aggregate fact tables from staging

Hi, Is it acceptable to create an aggregate fact table from the staging tables after you have cleaned out the data in staging? I know usually you're supposed to create aggregate fact tables from the fact/dimension tables, however can it be done straigh

Stage Table for Fact Data

Is it a best practice to truncate a stage table before every load? --- RPC

Fact dimensionality

I often run into the situation the we have several fact tables with different grains, but are related through a single ID at the transaction level. Typically the dimensionality is the same, but the related information doesn't exist in the source

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

Staging Activities

What are the common staging activities that the Kimball method recognizes? Traditionally I have used staging databases to 1) Decouple from the source-to-Data Mart for restartability 2) Consolidate multiple sources and source formats into a single

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

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

Data Warehouse with high data availability

When a data warehouse is being updated by periodical ETL load, there could be significant performance impact on the end users' reports while the underlying tables are touched. The data becomes volatile and the query results could be different between

New Release Media Companion gen2 3.148

Just a small update on 3.143 New feature for Movies, support for <sortorder> tags. The field is below the Movie title, by default it is the same as the title, but xbmc will list movies alphabetically according to what is in this tag. You ca

Kirby's Epic Yarn!

So I got this today! Everybody with a soul enjoys some Kirby every now and then. This si Kirby's first console platformer game since Kirby 64 way back in 2000, I think it was. Time flies, eh? So here is what Sparky thinks of it: First off, Toys R' Us i

Playthrough 2.5 Question!

Ok, so I've completed the game on PT2 this morning. So PT2 should be PT2.5 now right? I've seen pictures on here of level 60 drifters and on my friends PT2.5 Knoxx was level 61 and everything else was level 60. Drifters are level 55 on mine, Knoxx Is

Best Practices for SCD Dimension Tables for a Banking Data Warehouse