< 1 2   Sort: Rank

What are levels in dimensions
What are levels in dimensions ? Dimensions are arranged in hierarchical levels, with unique positions within each level. For example, a time dimension may have four levels, such as Year, Quarter, Month, and Day. Or the dimension might have only three levels, for example, Year, Week, and Day. The val...
2007-10-25, 4538👍, 0💬

What are dimensions in OLAP
What are dimensions in OLAP ? Dimensions are the categories of data analysis. For example, in a revenue report by month by sales region, the two dimensions needed are time and sales region. Typical dimensions include product, time, and region.
2007-10-25, 4486👍, 0💬

What is a measure in OLAP
What is a measure in OLAP ? Measures are the key performance indicator that you want to evaluate. To determine which of the numbers in the data might be measures. A rule of thumb is: If a number makes sense when it is aggregated, then it is a measure.
2007-10-25, 6593👍, 0💬

What is the use of OLAP
What is the use of OLAP ? OLAP is useful because it provides fast and interactive access to aggregated data and the ability to drill down to detail.
2007-10-25, 4744👍, 0💬

How can you increase SQL performance
How can you increase SQL performance ? Following are tips which will increase your SQl performance Every index increases the time takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be too much. Try to use maximum 4-5 indexes on one table, not more. If you have read-on...
2007-10-25, 4608👍, 0💬

What are indexes? What is the difference between stered and nonclustered indexes
What are indexes? What is the difference between clustered and nonclustered indexes? Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quickly. There are clustered and nonclustered indexes. A clustered index is a special type of index that reorders the...
2007-10-25, 4348👍, 0💬

What are the different types of joins? What is the difference between them
What are the different types of joins? What is the difference between them ? INNER JOIN Inner join shows matches only when they exist in both tables.Example, in the below SQL there are two tables Customers and Orders and the inner join in made on Customers Customerid and Orders Customerid.So this SQ...
2007-10-25, 4494👍, 0💬

What is a candidate key
What is a candidate key ? A table may have more than one combination of columns that could uniquely identify the rows in a table; each combination is a candidate key. During database design you can pick up one of the candidate keys to be the primary key. For example, in the supplier table supplierid...
2007-10-25, 4687👍, 0💬

What is denormalization
What is denormalization ? Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance.The sacrifice to performance is that you increase redundancy in database.
2007-10-25, 4844👍, 0💬

What is normalization? What are different types of normalization
What is normalization? What are different types of normalization? It is set of rules that have been established to aid in the design of tables that are meant to be connected through relationships. This set of rules is known as Normalization. Benefits of normalizing your database will include: 1. Avo...
2007-10-25, 6718👍, 0💬

< 1 2   Sort: Rank