Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg: Fact table and Dimension table in Data Warehousing -

915396Jun 12 2013 — edited Jun 12 2013

Hi Experts,

I'm not exactly getting the difference between the criteria which decide how to create a Fact table and Dimension table.

This link http://stackoverflow.com/questions/9362854/database-fact-table-and-dimension-table states :

  • Fact table contains data that can be aggregate.
  • Measures are aggregated data expressions (e. Sum of costs, Count of calls, ...)
  • Dimension contains data that is use to generate groups and filters.

This's fine but how does one decide which columns to consider for Fact table and which columns for Dimension table?

Any help is much appreciated.

Pardon me if this's not the correct place for this question. My first question in the new forum.

Thanks and Regards,

Ranit Biswas

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2013
Added on Jun 12 2013
8 comments
669 views