Primary Key of Fact Table

fact primary key

Hi My data warehouse will have CONTRIBUTIONS fact table which is sourced from a OLTP General Ledger Table. All transactions from the GL table will be put in a ODS staging table (GL_Stage). The GL table primary key consists of 9 fields (transaction

Primary Key of Dimension and Fact Tables

I've seen several people give presentations which purport to represent the Kimball Method and I've seen this done two ways. What is the current position on what should be the primary key of a dimension table? I was under the impression that we

How to avoid duplicate Records in the fact table?

I have a periodic snapshot fact table to capture the business process "real estate sales". Then we have one row per property per buyer per day, that to say a property can be sold at most once in a day to one buyer. Now I want to ensure data quality an

Index Strategy on FACT Table with 300 Million records

I have a FACT table with 30 Foreign Keys and 4 Alternate Keys. This table will have 300 million records and is going to be partitioned based on Date key. Would like to some advise on Index strategy. Thinking of, 1.Create single column all FK indexe

Surrugated key in fact table

I´m in charge of making the telemarketing database in my company so Ive made a fact table with a atom grain of one record for every telephone for channell for campain and I include a surrugate key and a child key so this way I can make a inner join and

Can a fact table be used as a source for populating another fact table

Scenario: There are two source tables : 1. SRC_INV_HDR (1 million rows in a year) 2. SRC_INV_DISCREPANCIES (1lac rows in a year) Landing tables in ODS : DWI_INV_HDR DWI_DISCREPANCIES Two fact tables : 1. DWB_Invoice_hdr 2.

Montly Snapshot views with transactional Fact table w/SCD2

I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

2 fact at different granuality demanding different level of a dimension hierarchy.

Hi, Here is what i am trying to design. There is a transaction level fact table say Fact1.. One of the dimensions for this fact table is Dim1, which has hierarchy as L1>L1>R1.. leaf to root. The Leaf node (L1) of the dimension is Foreign key in the

Example 5: Widgets as Pop-Ups!

I don't know about you, but I think the display of widgets makes a forum look cluttered at best, and ugly at worst. Widgets take away from what's important on a forum...the content. But widgets do have the ability to display useful information. So

"The lab": Raging Were

Alright, this is back at the lab… Evil humans gathered in the compound that was known as, “the lab”. It didn’t start out as much, just people gathering and sharing ideas on how they could improve the world of science. Some of the people attending the

If you had one million dollars...

What would you spend it on?