Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    HYD
    Posts
    1

    Thumbs up Unanswered: Semi-Additive & Factless Fact

    Dear Gurus,

    I am new for Data Warehouse. Plz Can any body help me..

    What are Semi-additive and factless facts? And in which scenario will you use such kinds of fact tables?

    Thanks in Advance,
    Srivardhan

  2. #2
    Join Date
    Sep 2003
    Posts
    156

    Re: Semi-Additive & Factless Fact

    Originally posted by srivardhan
    Dear Gurus,

    I am new for Data Warehouse. Plz Can any body help me..

    What are Semi-additive and factless facts? And in which scenario will you use such kinds of fact tables?

    Thanks in Advance,
    Srivardhan
    Facts can be described as additive, non-additive, semi-additive.
    Additive: can be meaningfully summed across all dimensions
    Semi-additive: …………………….. across some dimensions
    Non-additive: can’t be …

    A factless fact table has no measurement metrics.
    These types of fact tables record occurrences of events

    i hope this answers your question
    rgs,

    Ghostman

Posting Permissions

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