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

BlakeBlake
As your older brother, I've been where you are—maybe not exactly, but close enough.
Chat with Blake
MaxineMaxine
I respect you enough to keep it real.
Chat with Maxine
ReneRene
Change my mind. I dare you.
Chat with Rene
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