Take FREE!! Online Cocubes Mock Test to Crack various Companies Written Exams.
Get Off-Campus Placement Jobs Info !!!
Take 30+ FREE!! Online Arithmetic Aptitude Mock test to crack any Exams.
Technical Discussion :: Informatica

32 / 94

Different types of facts.

Answer:

Type of facts are:

Additive: Additive facts are facts that can be summed up through all of the
dimensions in the fact table. A sales fact is a good example for
additive fact.

Semi-Additive:Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others.

Eg: Daily balances fact can be summed up through the customers dimension but not through the time dimension.

Non-Additive:



Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.

Eg: Facts which have percentages, ratios calculated.

Asked In ::

Post Your Answer Here:


Rate This: +0 -0     
Report    

Post Your Reply Here:

Alert me
q4i-reply-your-answer

Report Error

Please Login First Click Here

Most Popular Qs.