Warehouse Concepts Job Interview Questions

All Categories >>

Data Warehouse >>

Warehouse Concepts >>

uestion

Explain What are non-additive facts in detail?

Question Submitted by: Admin

Post New Question.

Answer

# 1

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 for a particular place for a particular period of time, we can add the dollar amounts and come up with the total amount.

A non additive fact, for eg measure height(s) for 'citizens by geographical location' , when we rollup 'city' data to 'state' level data we should not add heights of the citizens rather we may want to use it to derive 'count'

which cant be summed up with any columns in the table(all dimension keys)
EX: ratio columns,profit margin

Answer Submitted by: Admin

Is This Answer Correct?

0 Yes

0 No

Download Warehouse Concepts Interview Questions Download Free Warehouse Concepts Job Interview Questions And Answers

Previous Interview Question	Next Interview Question
Explain What is the difference between OLAP and datawarehosue?	What is cubes?

Question Published at Thursday, 07 July 2011 in Category Warehouse Concepts. Question Visited: 330 Times.

Top: Explain What are non-additive facts in detail?

Warehouse Concepts Job Interview Question

Subscribe your email to receive free updates:

Enter your email address and get free job hunting tips, career advices, job vacancies, interview questions updates directly delivered to your email inbox

Most Frequently Asked Warehouse Concepts Interview Questions

☺	What is the difference between ODS and OLTP?

☺	Explain What are non-additive facts in detail?

☺	Explain Is OLAP databases are called decision support system true/false?

☺	What is cubes?

☺	What is active data warehousing?

Top Frequently Asked Warehouse Concepts Question

Frequently Asked Warehouse Concepts Job Interview Question

Most Frequently Opened Interview Questions Sub Cateories in Data Warehouse

☺	ETL (Extract, transform, load) Interview Questions and Answers Guide

☺	Data Warehousing Interview Questions and Answers Guide

☺	ColdFusion Interview Questions and Answers Guide

☺	Ab Initio Interview Questions and Answers Guide

☺	Cognos Data Warehouse Interview Questions and Answers Guide

Top Frequently opened Data Warehouse Job Interview categories

Most popular Data Warehouse Job Interview categories

Comments About Explain What are non-additive facts in detail?

Share your valuable opinions, ideas and suggestions about Explain What are non-additive facts in detail?
While placing your comment your email address is required but won't be published any where else; Personal information will be kept confidential; we do not sell or release our respective visitors private information.

Webmaster 18th of June 2013

Tell us what you feel about Explain What are non-additive facts in detail?
All comments will be published after review. No login or registration is required to post a comment on Explain What are non-additive facts in detail? We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
So start sharing your thoughts regarding Explain What are non-additive facts in detail?
Thank you.

Reply