.Net Interview Questions and Answers

Search:

SQL Server interview questions: - What is the difference between Fact Table and Dimensions?

By : Shiv Prasad Koirala | May 7th, 2014 | Views : 2768 | Comments : 0 Bookmark and Share

Fact Table contains two things: -


  1. Foreign keys which pointing to primary key in dimension tables.
  2. Measures - This identifies some numbers in a business. Example Total number of sales, amount given, purchased amount etc.


Dimension tables contain denormalized data. Every record in this table will contain a unique identification key which will refer by Fact Tables.


Data warehouse design - It's all about creating dimensions and fact tables.


1)  Dimensions are extracted from traditional database. Multiple tables in a traditional table are joined and considered as one

     dimension table.

     Example - Let say we have following database with use

     Customer ( CustomerId, CustomerName, CustomerMobile, CItyId, GroupId)

     City (CityId,CityName)

     Group(GroupId, GroupName)


     Dimension table will look like this,

     CustomerDimension(CustomerId,CustomerName,CustomerMobile,CityName,GroupName)


2)  Fact table will be created containing only numbers and foreign keys pointing to other dimensions.
     Now let say we have following dimensions

    CustomerDimension(CustomerId,CustomerName,CustomerMobile,CityName,GroupName)

    TimeDimension(Timekey,Year,Month,Day)

    ProductDimension(ProductId,ProdudctName,ProductPrice, ....)


    Now One Fact table look like

    ProductSale(ProductId,CustomerId,TimeKey,QtySold)


For technical trainings on various topics like WCF, MVC, Business Intelligence, Design Patterns, WPF, TFS and basic fundamentals feel free to contact SukeshMarla@Gmail.com or visit www.sukesh-marla.com


For more stuff like this, click here. Subscribe to article updates or follow at twitter @SukeshMarla


Also see our SQL Server interview questions video on triggers, inserted and deleted tables: -


 
Rate this Article :
1 Star
2 Stars
3 Stars
4 Stars
5 Stars
1 1 1 2 1
 
 
 
 

.NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala

In this article we will explain .NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala.... Read More

What is the difference between Stored Procedures and Function (SQL Server interview question with answers)?

In this article we will explain what is the difference between Stored Procedures and Function.For more articles and videos visit us on www.questpond.com... Read More

Explain MVC application life cycle?

In this article we will explain MVC application life cycle.For more articles and videos visit us on www.questpond.com... Read More

C# Design pattern interview questions with answers: - How Singleton is different from Static class?

In this article we will explain How Singleton is different from Static class.... Read More

WCF interview questions and answers: - What is the difference between Service endpoint and Client endpoint?

In this article we will explain What is the difference between Service endpoint and Client endpoint.... Read More

.NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala

In this article we will explain .NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala.... Read More

What is the difference between Stored Procedures and Function (SQL Server interview question with answers)?

In this article we will explain what is the difference between Stored Procedures and Function.For more articles and videos visit us on www.questpond.com... Read More

Explain MVC application life cycle?

In this article we will explain MVC application life cycle.For more articles and videos visit us on www.questpond.com... Read More

C# Design pattern interview questions with answers: - How Singleton is different from Static class?

In this article we will explain How Singleton is different from Static class.... Read More

WCF interview questions and answers: - What is the difference between Service endpoint and Client endpoint?

In this article we will explain What is the difference between Service endpoint and Client endpoint.... Read More

Article Categories

Learn in Hindi