Answer Posted / marcelo malheiros

I believe you lost the begining of my answer...

"I know a lot of people understand ROLAP and MOLAP as where
the information is stored: if data is in a RDBMS, is ROLAP;
if it is in a self-contained cube, it is MOLAP.

I find the above a misconcept of the terms."

Let me repeat the fundamental question: How would classify
On Line Analytical Process performed on top of IMS, IDMS,
ADABAS, VSAM, flat file, XML and other non RDBMS data
storages?"

Explain why fact table is in normal form?

920

---

How to generate the cubes in framework manager?

965

---

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

1000

---

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

954

---

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1037

---

What is the function of etl when used in data warehousing?

900

---

Why is business intelligence (bi) important in data warehousing?

883

---

What is the difference between olap and oltp?

972

---

How to stop a batch?

914

---

What are templates in which way it is help full?

939

---

What is latest version of power center / power mart?

989

---

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

904

---

How can we schedule the graph in unix?

934

---

Code the tables statement for a single-level (most common) frequency?

881

---

What is difference between query studio and report studio?

1038

---