Answer Posted / mallika
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 lookup 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
| Is This Answer Correct ? | 107 Yes | 16 No |
Post New Answer View All Answers
What is the extension of file to save template?
Explain why fact table is in normal form?
What is cubes?
what are the all possible features supported modify stage?
How to create context?
What are the different types of schemas used in data warehousing?
Explain the versions of reportnet?
Explain how many ways you create ports?
Why facts table is useful in representing the data?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
What is many-to-many dimensional model in datawarehousing ?
How to generate the cubes in framework manager?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What are fact, dimension, and measure?
What is a linked cube?
