Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 53237 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / harshad
A fact table typically has two types of columns: those that
contain numeric facts (often called measurements), and
those that are foreign keys to dimension tables. A fact
table contains either detail-level facts or facts that have
been aggregated. Fact tables that contain aggregated facts
are often called summary tables or aggregated fact. A fact
table usually contains facts with the same level of
aggregation. Though most facts are additive, they can also
be semi-additive or non-additive. Additive facts can be
aggregated by simple arithmetical addition. A common
example of this is sales. Non-additive facts cannot be
added at all. An example of this is averages. Semi-additive
facts can be aggregated along some of the dimensions and
not along others. An example of this is inventory levels,
where you cannot tell what a level means simply by looking
at it.
| Is This Answer Correct ? | 52 Yes | 3 No |
Post New Answer View All Answers
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
How to drill through from a powerplay cube to reportnet?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Explain conformed fact?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What are diagrams?
Explain what is real time data-warehousing?
What are the various methods of getting incremental records or delta records from the source systems?
Explain is olap databases are called decision support system true/false?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What is the purpose of Dataware Control?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain what is the difference between olap and datawarehosue?
What is data warehosuing hierarchy?
What are the difference between snow flake and star schema?
