What are non-additive facts?
Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What are non-additive facts ? 24.09.08
fact table typically has two types of columns: those that contain numeric facts (often called measurements), and those that are foreign keys to dimension tabl...What is Dimensional Modelling? 23.09.08
Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two...What is conformed fact? 22.09.08
Conformed dimensions are those table that have a fixed structure. there will b no need to change the metadata of these tables and they can go along with any num...What is BUS Schema? 20.09.08
BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts. In a BUS schema we would eventually have conformed dimens...What is Dimensional Modelling ? 18.09.08
Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two...Can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible? 18.09.08
if you are a Report developer 1,you have to specify the front end and back end tool used for creating the reports 2,Then you have to tell the purpose of the p...What are types of Facts? 04.08.06
There are three types of facts: Additive: Additive facts are facts that can be summed up through all of the dimensions in the fact table. Semi-Additive: S...What are non-additive facts in detail? 04.08.06
A fact may be measure, metric or a dollar value. Measure and metric are non additive facts. Dollar value is additive fact. If we want to find out the amount...What are conformed dimensions? 17.03.06
Conformed dimensions mean the exact same thing with every possible fact table to which they are joined Ex:Date Dimensions is connected all facts like Sales fac...What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables? 17.03.06
Snapshot facts are semi-additive, while we maintain aggregated facts we go for semi-additive. EX: Average daily balance A fact table without numeric fact colu...