Q : What is Cube ?
A cube is a set of related measures and
dimensions that is used to analyze data. A Cube is the primary
storage mechanism for SSAS data. It consists of at least one fact table and
many dimension tables. The rows in these tables have a key relationship to each
other.
Q : What is fact table ?
A fact table is the center table surrounded by a dimension
tables. All the dimension tables directly or indirectly connected with the fact
table.
A fact table contains foreign keys to relate the rows in the
fact table to the dimension table rows and facts. Facts are key performance
indicators, for example net sales dollar, net sales unit, etc. Facts are
usually numeric and additive.
Q : What is a dimension table ?
Dimension table consists of one or more source tables.
Dimension tables have three types of columns. The first is the original primary
key for each row. The second is a new primary key (Or surrogate key) for each
row. This key is used to guarantee uniqueness, because the original data could
come from multiple sources. The third is a column for each attribute that describes
each dimensional value.
Facts tables play a very dynamic role in the data warehouses or data marts because they consist of the measurements, metrics or facts of a business process e.g., sales revenue by month by product. Fact tables usually contain large numbers of rows, sometimes in the hundreds of millions of records when they contain one or more years of history for a large organization.
ReplyDeletehttp://www.sql-datatools.com/2015/09/data-warehouse-data-marts-fact-tables.html
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in MSBI, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on in MSBI. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/
Very nice article...Thanks for sharing the best information...
ReplyDeleteCareer Opportunities in MSBI
It’s amazing in support of me to have a site, which is useful in support of my know-how. thanks admin|, you surely come with remarkable articles. Cheers for sharing your website page.Excellent blog here...
ReplyDeleteDataware Housing Training in Chennai | Hadoop Training in Chennai