.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

What are Fact tables and Dimension Tables?

Posted By :Sagar Pardeshi     Posted Date :February 27, 2010    Points :10   Category :Sql Server 
A fact table typically has two types of columns: those that
contain facts and those that are foreign keys to dimension
tables. facts may be composed of measures,degenerated
dimensions.The primary key of a fact table is usually a
composite key that is made up of all of its foreign keys

Dimension tables, also known as look up or reference tables,
contain the relatively static data in the warehouse.
Dimension tables store the information you normally use to
contain queries. Dimension tables are usually textual and
descriptive and you can use them as the row headers of the
result set. Examples are customers or products

You can also find related Interview Question to What are Fact tables and Dimension Tables?  below: 

How many types of tables are present in SQL SERVER?

  
There are 2 types of temporary tables, local and global in sql server.

Local temporary tables are created using a single pound (#) sign and are visible to a single connection and automatically dropped when that connection ends.

Global temporary tables are created using a double pound (##) sign and are visible across multiple connections and users and are automatically dropped when all SQL sessions stop referencing the global temporary table. (More...)

What are magic tables?

  
Sometimes we need to know about the data which is being inserted/deleted by triggers in database. With the insertion and deletion of data, tables named "INSERTED" and "DELETED" gets created in SQL Server which contains modified/deleted data.
Here "INSERTED" and "DELETED" tables are called magic tables. (More...)

Is it possible to have tables in the dataset that are not bound to any data source?

  
Yes, I can create table object in code and add it to the dataset. (More...)

What is the Magic Tables in Sqlserver2000?

  
In Database for any table or view When a trigger is fired for any DML command.
Then 2 tables automatically create on backend.
One table is for Insert and other one is for Delete.
These tables are called Magic Tables.
Number of records in both tables should be same. (More...)

What is Fact and Dimension table?

  
Fact Tables:
A fact table typically contains the business fact data. Examples are sales amount, sales quantity, and the number of customers and the foreign keys to dimension tables.

Dimension Tables:
A dimension table contains data that we'd like to use to group the values we are summarizing. (More...)

Get data from 2 tables using join?

  
Select s.name,s.code,m.eng,m.math from Student S INNER Join Marks m on s.RollNo=m.RollNo; (More...)

What are the ways you can display all the tables in Sql Server?

  
Way 1:

SELECT Table_Name
FROM information_schema.Tables

Way 2:

SELECT Name
FROM SysObjects
WHERE Xtype = 'U' (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend