Combination of SCD2, partial snowflake, Effective and end dates in fact table
We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

What can i expect to see at Arkham Gaming Centre?
Our gaming space includes eight tournament sized (8'x4') terrained tabletop wargames tables (wastes, desert or forest), two 4'x'4 tables for board/card games, four multi-purpose gaming tables which can be used for board, card or wargames (option of blue

BRIDGE TABLES
Hi In my data warehouse I have the following two dimensions Customers and Accounts, a customer can have 1 or more accounts, both are SCD Type 2 dimensions. To show the relationship between the dimensions I am considering creating a bridge

Rapidly changing Monster dimension...
Hi Everyone, I have a list of more than 300 attributes, which are actually part of the fact table….(basically ..these values changes for each transaction level record in fact but belongs to a single dimension). that lot contains more than a 100 date

Fiscal Dim and Snapshot Dates for Budgets
Hi everyone, I have a couple of questions regarding fiscal dates and snapshot dates/data: 1. How would someone model a "fiscal" dim when a date maps to two fiscal months? e.g. Fiscal Year 2010 Fiscal Month 12 Fiscal Month Date

Monster Dimensions
My customer list is huge (about 70 millionish). We currently have a 60 million row dimension (CUSTOMER) that holds most of our existing customers, and this existing large DIM is currently performing fine for us. Now my clients want to type 2 two

Question on symmetry in Star schema
Hi I read Kimball's Data warehouse toolkit and I came across a point that one of the advantages of having star schema is - BI / reporting tools in the market can leverage the symmetrical nature of the star schema. From what I know and I could

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

Dynamic dimensions
What is the best way to handle dimensions that change depending on user parameters? For example, lets say you want "Months Since Inception" to be a dimension, because you want to bucket by it (i.e. 0 to 50 Months, 51 to 100 Months, etc.) but

Converting dates to integer
I am in the process of building a datawarehouse. The OLTP has dates like "date_enforced", "date_entered" in the datetime format. How do I convert this to integer in SSIS since my date dimension has the datekey as integer in the YYYYMMD

Mini Dimensions
Hi In out data warehouse design (superannuation) we need to cater for Client and Accounts and the relationship between them (a client can have one or more accounts). Some of the client attributes can change so we were thinking or having a client

Finish background
Can someone help getting rid of the white around the following image? Thanks

Start Schema vs Snow flake schema
In my organisation we are on a way to implement data warehouse and data mart for sale. we have one dimension City/District/Store. 1. Store name can be split/merge from one district to other in next quarter. 2. there is possibility of changing City nam

I need an image to finish this set
I have these icons: I need a clock one to mach it please. Transparent, 16 by 16 please

When/How did you start vidding?
Title says it all, 'nuff said As for me, I'm not exactly sure HOW I started vidding... it seems like ages ago xD. But I'm certain, that I began vidding with Windows Movie Maker in 2005-2006. Wow, I was so excited with that crappy old program, that I