Take a look at the following Image.. The yellow shaded columns are fact columns and the remaining columns are key columns , which will be used to connect to dimension tables..
Friday, November 26, 2010
What is a Fact Table?
A fact table is also a Table in the database contains Facts (Measures such as quantity sold, revenue, account balance) and foreign keys. ( These keys will be used to connect to various dimension tables such as Product, Time, Customer, Staff to get information like product name, staff name, customer name etc..)
Take a look at the following Image.. The yellow shaded columns are fact columns and the remaining columns are key columns , which will be used to connect to dimension tables..
Take a look at the following Image.. The yellow shaded columns are fact columns and the remaining columns are key columns , which will be used to connect to dimension tables..
Subscribe to:
Post Comments (Atom)
Thanks for your posting , which helped me to join cognos online training @ www.monstercourses.com
ReplyDelete