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 are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What needs to be done when the database is shutdown?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain some of modeling tools available in the market?
How are the dimension tables designed?
Explain the importance of data warehouse?
Explain about core dimension,
Explain degenerate dimension table?
What is execution plan?
Explain how many ways you create ports?
What is the difference between olap and datawarehosue?
Explain the versions of reportnet?
Explain ddl (data definition language)?
Store (and count) non-fact records?
Explain which columns go to the fact table and which columns go the dimension table?
