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.

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.

2038

---

Why is chameleon method used in data warehouse?

1215

---

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

997

---

What is informatica architecture?

1112

---

Difference between e-r modeling and dimentional modeling?

986

---

Explain the definition of normalized and denormalized view?

939

---

Explain why denormalization is promoted in universe designing?

999

---

What are parallel querys and query hints?

2275

---

How can we load the time dimension?

1250

---

ware house management system is used?

1053

---

What is data stream and data adaopter. Is it same are different? Explain?

1084

---

Explain what are non-additive facts?

1071

---

Explain where do we use semi and non additive facts?

1061

---

Explain the difference between view and materialized view?

980

---

Explain what are the vaious etl tools in the market?

981

---