Linking or Merging Similar dimensions from Different Source Systems...

Best Praticte for inserting fact and linking to dimensions

Hi all, is it allowed to have null values in fact table for some dimensions foreign keys ? Exemple : DateDimFk DimFk1 DimFk2 50 (coming from business system 1) DateDimFk null DimFk2 50 (coming from business system 2) or do i have to create a

Bus Matrix - Business Process -to- Source System not 1:1?

We have a number of source systems that all do the same thing- receive loan applications. The reason for multiple systems is because some are web-based, some are for B2B, and some are legacy. So, do we list three separate Business Processes on the Bus

Kimball Dimensions

I got into a nice heated debate the other day. The item of discussion was flattened dimensions. Id like to know your opinion (or facts) about the following, (Some of this is common sense please still give me some feedback). Any article citations

Can Data Warehouse be used as source for operational system

What are the pros and cons of using Data Warehouse (DWH) as source for an operational system? Background:- I work for a company who have now opted to use DWH to populate some of the small operational system's data base, The data in the DWH is

A dozen systems with many dimension codes

Hi, I have more than a dozen systems to integrate, and each has it's own version of dimension codes. The source systems need to use dummy codes, and multiple codes for one entity. This for operational reasons. So, to conform a dimension I have a

Merging Posts

Could it be possible to merge posts? Also my thread for News on Homepage, it got 90% yes and 10% no.

Merging posts

Do you think it would be great if we have automatically merging posts from the same user that may be posted one after another? Let's say, if someone doesn't use the "multi-quote" button and use the "quote" button for each post he

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

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

Iraqi Kurdistan and Are Critical of Linking Independent Bodies of the Cabinet

Iraqi Kurdistan and Are Critical of Linking Independent Bodies of the Cabinet 22/01/2011 Enemy «violation of the Constitution» and demanded that the House of Representatives and the political blocs to take a stand Baghdad morning Description of

simbro - test for "take a walk" function

please bear with me as this is my first attempt at releasing a version I have implemented a test for the "take a walk" function in the "manage" window. It has no effect on the game so far, it is just to see if it is working

I screwed up...now what?

I had a killer migraine last night, so instead of taking one of my few Gravergol, I took an old maxalt. (Don't ask me why, I was clearly not thinking). Now I'm brewing another 7-8 and I have no maxalt. I have other triptans, but no maxalt. Can I

Option to disable off-site links from Traffic Exchange/Similar Topics

This seems to be the only way we'll be ever listened to. Forumotion has recently launched a beta feature called Traffic Exchange, currently available for English forums only. This new option on the AP displays a block of 6 links at the bottom of each