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 the difference between view filter and report filter?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain what are non-additive facts in detail?
Explain why should you put your data warehouse on a different system than your oltp system?
What are session timeout and application timeout?
What are the differences between star and snowflake schema?
What is meant by metadata in context of a data warehouse?
What is surrogate key? Explain with examples.
What are session timeout and application timeout? Where we have to do this process?
Explain the definition of normalized and denormalized view?
How to pivot data using informatica when you have variable amount of pivot rows?
How can you implement many relations in star schema model?
What is mean by aggregate aware?
What is application.cfm?
Suppose we want to display zero when null values coming to report how can we do that?
