Hi,

Just on the business keys. The data is actually sourced from 3rd party systems. The data is loaded from these systems through to the staging tables by the ETL process....

MMartin1 (12/9/2016)

---

I think it is a good idea to keep the business ID along with your surrogate key definitely. As far as the source, that sounds to me more for...

Thanks! Currently reading it.

Should I always have an identifier key in each dimension that points back to the source/staging table?

Chris Harshman (11/22/2016)

---

OK, the fact table looks better, but I'd need to understand the business a little better to know why you still have multiple balances in the fact. Will...

Chris Harshman (11/21/2016)

---

I still see 2 foreign keys from the fact to Account table, and 2 foreign keys from the fact to Broker table. In a post on 11/16...

Hi,

I have updated my design to add a Source table. I have added the SourceKey to the fact table and removed the source reference from the other dimension tables.

Is this...

The question to the OP is ... are CounterpartyAccountKey and GenevaAccountKey mutualy exclusive? It appears to me from the reading that they may very well be (normally a record only...

Think of an order with an order data and a delivery date, most likely those will not be the same. If you use a single instance of a date dimension...

Hi, any reason why this might...

Hi,

How do I allow for an item in SourceA to be matched to an item in SourceB?

So in my report output, if the user has indicated these 2 items are...