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.

What is surrogate key? Where we use it?

932

---

Explain me what are conformed dimensions?

950

---

Explain er diagram?

934

---

What is the difference between view materialized view and view?

1024

---

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

988

---

How to stop a batch?

914

---

Explain what are fact, dimension, and measure?

933

---

Explain the data types present in bo n wht happens if we implement view in the designer n report?

918

---

How can we schedule the graph in unix?

934

---

Explain the difference between filter and conditin?

910

---

How to create prompts in report net?

939

---

What is data analytics in simple terms?

1081

---

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

901

---

What is the advantages data mining over traditional approaches?

906

---

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2057

---