Answer Posted / anup kumar dash

DSS(Decission support system) which helps to take decission
for the top executive people. it generally based on
historical data

OLTP(Online trasnaction processing)system is the the
system where day to day transaction are taking into
consideration. it based on current data.

Anup Kumar Dash

Explain what are the various file formats involved in reportnet?

935

---

What is Discover and Execute in XMLA?

2405

---

Explain what are the tasks that loadmanger process will do?

925

---

Tell me what is full load & incremental or refresh load?

950

---

Compare aggregates and data marts

2762

---

Explain why fact table is in normal form?

968

---

Explain dimensional modelling?

972

---

How did you plan your Data ware house project?

2299

---

How to drill through from a powerplay cube to reportnet?

937

---

Explain what is real time data-warehousing?

1101

---

What is meta data and system catalog?

2296

---

Explain the versions of reportnet?

985

---

After the complete generation of a report who will test the report and who will analyze it?

977

---

Explain which columns go to the fact table and which columns go the dimension table?

924

---

Can a dimension table contain numeric values?

1052

---