Business keys in Fact. Is this accepted?

raikarleena at 00h28
11
Mar
2009
Business keys in Fact. Is this accepted?

It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted.

Ex: Event_Type_DIM: this has 2 columns (event_type_code,event_type_description) where code store 4 values:SMS,VOICE,GPRS,RECHARGE. Its basically a code that generated revenue.

Currently these Codes (V

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
DATE OR DATE KEYS IN FACT TABLES
I've read different opinions about the usage of dates in fact tables. If a date is NEVER used to filter and only reported, what is the purpose of adding it as a date key instead of a plain date type? Aren't we wasting the resources to get to the date
Business Objects and joins across two (large) fact tables
In a business objects universe, I have several fact tables which are related by various dimensions. If I want to select facts from two of the fact tables, business objects will generate two separate queries, run the SQL and join the two results sets in th
Modeling Question - Accumulating Snapshot vs. Event Transactions
I have a business process that has 6 distinct steps from start to conclusion for each instance of the process, we'll call it a case. Each case has two employees assigned to it, 1 owner and 1 co-owner. The owner and co-owner each have different
Fact table with non-numeric measure
I have a transactional fact table containing results of inspections. The results are non-numeric, but do represent a measurement, that is inspection result (like "pass", "fail", "pass with infraction", "failure with
Derived Fact table with additional measures / foreign keys ... ?
Hi, Let's say we have a fact table: FactReceipt which contains all our receipting transactions that occur during the month, we may have 5 receipts of different types during one month for one contract. Now let's say we build another fact table that
Forums from same category
See also
more_less
Informations

5 Replies For the topic :
"Business keys in Fact. Is this accepted?"

This topic has been viewed 905 times.

Last message :
11/03/2009 at 00h28 by "raikarleena"