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 steps involved in creating dimensional modeling process?
Which are the olap tools available that are supported by oracle?
Explain datawarehousing?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What does level of granularity of a fact table signify?
How to limit the max no of rows retrieved in the report?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain can a dimension table contains numeric values?
Explain how to generate iqd file from framework manager?
What is hybrid slowly changing dimension?
What are the reasons to use a chameleon method in data warehousing?
Explain clustering algorithm?
Explain what are the advantages data mining over traditional approaches?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Explain ddl (data definition language)?
