A dozen systems with many dimension codes

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

Baker's Dozen

Each person takes turns in making a list of 13 things in a category, plus the 13th person gets to choose the next category. I'll kick off with 13 Manchester bands: 1. Puressence

Language translation for large number of codes

The significant dimension tables in our data model each contain 25 or so codes. Example currency code, category code etc. Each of these dimension tables have different sets of codes i.e they do not share identical sets of codes. Each code requires

Dimensional modeling for operational systems

It seems to me that dimensional modeling is adequate for database modeling even for operational systems. From my perspective, a dimensional model can register any set of business process and it is already adequate for query. If the whole organizatio

How to consolidate numerous ETL processes?

Hi, Within the department there are numerous users whose ETL processes are slightly identical to one another (e.g. an extra variable). This not only puts a burden on the server load, but also create problems where a certain measure is not identical

Gambling Systems And ChatBox Stickys

Hey Guys Today This Is My First Post And I Have A Thew Suggestions That I Think Can Benefit ForuMotions Forums Community And Help It Make Your Forum More Fun And Attractive 1. A Gambling System , On My ForuMotion Forum My Reward Points Are Called FGz

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

Ability to show codes

Well, on my forum, you must post 6 posts to be able to visit the rest of the forum. But I want to alter it a bit, I would like to make so if you read through topics you can find a code. Using that code, you must enter it in to a Code Authorization System

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

Dimension with two hierarchies

I need to design a dimension with two hierarchies 1. Location -> Building -> Room -> Cabin 2. Location ->Building I need the hierarchy 1 to be referenced in one FACT table and hierarchy 2 in other FACT. But my ETL tool allows only the dimension ke

Bridge table for patient diagnosis

Hi ngalemmo or fourm members, Can I get advice on how to create a bridge table for patient diagnosis? To keep it simple, I have a patient, facilities, and doctor dimensions and one fact table. For a specific patient, I need to show all diagnosis in a