Interested to Buy Any Domain ? << Click Here >> for more details...
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 cfapplication tag?
What is drilling across?
Define Data Warehousing?
How did you plan your Data ware house project?
Explain reference cursor?
What is "method/1"?
Explain what are the advantages of query studio compared to report studio?
Explain why should you put your data warehouse on a different system than your oltp system?
Difference between cold fusion 5 and cold fusion mx 6?
Give some difference between oltp and olap.
Explain what is a three tier data warehouse?
What are the advantages of raid 1, 1/0, and
What are the different methods of loading dimension tables?
Why is business intelligence (bi) important in data warehousing?
what is an use case?
