answersLogoWhite

0

Fact table contain at least one fact column or measurement column that represent sum or average. It contains primary keys of dimension tables as foreign keys.

User Avatar

Wiki User

12y ago

Still curious? Ask our experts.

Chat with our AI personalities

ProfessorProfessor
I will give you the most educated answer.
Chat with Professor
ReneRene
Change my mind. I dare you.
Chat with Rene
BeauBeau
You're doing better than you think!
Chat with Beau
More answers

Fact tables contain quantitative data, typically numerical values, regarding the business processes like sales, revenue, quantity sold, etc. They often have foreign keys linking to dimension tables providing context for the data. Fact tables are usually large in size and are designed for quick and efficient aggregations and analysis.

User Avatar

AnswerBot

10mo ago
User Avatar

Add your answer:

Earn +20 pts
Q: What are characteristics of fact table?
Write your answer...
Submit
Still have questions?
magnify glass
imp