Get Subdimension (outrigger) count (built using Bridge Table)

Tracking Type2 SCD when using a dimension outrigger

With an outrigger table, a narrow band of attributes, usually with significantly lower cardinality than the main dimension, is in essence snow flaked off of the main dimension. Great technique for data management and maintenance. To hide complexity from

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

Confusion - star, snowflake, bridge table

Appreciate your expert comment on following: Entities: Quote, Trade, DIRequest, Order User, Customer, Trader, Sales or Marketer and Product - User is a user who is using the system or interfacing with the system. i.e. requesting quote or placing a

Bridge table for INSURANCE

HI, I am creating the Property & casualty Insurance DW for Autopolicy I have PolicyTransactionFact, DIM_covered_item_vehicle, Policyholder_dim these are FK's in the fact table. and I created driver dimension table which has driver

Bridge Table - Linking Facts ?

We are recording 2 sets of facts - Financial Trades and Trade Warnings. Trades Warnings occur when a certain set of related Financial Trades hit some programmed criteria. We need to to link the Trade Warning with the Financial Trades that caused the

Some Practical Challenges

Hi All I am facing some challenges in my dimensional modeling and most of these are covered in many books too.But i have practical limitation for that 1st Challenge :Unbalanced Hierarchy In one of the dimension we are tracking employees and their

Dimensional modeling on HospitalStay

a different question on The Data Warehouse Toolkit, 2nd Ed. The complete guide to Dimensional Modeling. In Chapter 13 page 265 "In a hospital stay situation, however, the diagnosis group probably should be unique to the patient because it is

vowel count

TITLE VOWEL COUNT .MODEL SMALL .STACK 64H .DATA MAXCHAR DB 20H ACTCHAR DB ? CHARS DB 20H DUP (?) ARRAY DB "AEIOUaeiou" TEMP DB 03H .CODE MAIN PROC MOV AX,@DATA MOV DS,AX LEA DX,MAXCHAR MOV

Total Episodes count not working

Hi All I'm new to Media Companion, so I assume I'm doing something incorrect, because when I run it on the TV show folders I have selected. It finds all the shows info, but I can’t get it to dispaly the Episodes or seasons. I know it has found the

Iraq to drive ME growth as GCC rig count stays same - Halliburton

Iraq to drive ME growth as GCC rig count stays same - Halliburton November 11 2010 MEED quoted two oilfield services companies working in the Middle East as saying that 2010 has been an improvement on 2009 and that they are looking at Iraq to

Update No. Of post count for users*

Update No. Of post count for users As i have seen many people asking for help regarding this topic, i thought of opening a thread in suggestions section so that we can vote and see if we get any outcome.. So ppl if you think that the Admins of a

Count from 999 to 0

Well, since we finished the 1000 counting game thread,, we'll have a new one this time we're going to count from 2000 to 0(backwards).. So who's gonna start?

100 reasons why Madeleine was not abducted

http://blogs.news.sky.com/discussions/show.html?plckForumPage=ForumDiscussion&plckDiscussionId=Cat:746f9309-1bb1-4b07-ad11-647f5ba16800Forum:4237bf3e-0948-444d-a452-46289a2fd1f7Discussion:53085ce6-d0e9-4517-9607-a2eb2b4b9b84 class=Discussion_PostTi