Results 1 to 2 of 2

Thread: Handling facts with unknown or no dimension keys

  1. #1
    Senior Member
    Join Date
    Aug 2012
    Posts
    40,312

    Handling facts with unknown or no dimension keys

    Suppose a fact row has an unknown dim keys, do you load that row or not? Can you explain the advantage/disadvantages?

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    We need to load that row so that the total of the measure/fact is correct. To enable us to load the row, we need to either set the unknown dim key to 0 or the dim key of the newly created dim rows.

    We can also not load that row (so the total of the measure will be different from the source system) if the business requirement prefer it. In this case we load the fact row to a quarantine area complete with error processing, DQ indicator and audit log. On the next day, after we receive the dim row, we load the fact row. This is commonly known as Late Arriving Dimension Rows and there are many sources for further information; .

Similar Threads

  1. Replies: 0
    Last Post: 03-20-2013, 01:40 PM
  2. Non-additive facts
    By Cora in forum ETL Testing
    Replies: 1
    Last Post: 11-07-2012, 05:55 AM
  3. Semi and non additive facts
    By MikeH in forum ETL Testing
    Replies: 1
    Last Post: 11-07-2012, 02:40 AM
  4. Facts and dimension tables in data warehouse
    By vijay in forum Data Warehouse
    Replies: 0
    Last Post: 08-07-2012, 11:47 AM
  5. Types of Facts
    By vivekmcm in forum Data Warehouse
    Replies: 1
    Last Post: 05-27-2012, 06:17 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •