Answer Posted / pravin

Operational Data store is a subject
oriented,integrated,current,volatile collection of data
used to support the tactical decision making process for
the enterprise. It is the central point of data integration
for busienss management,delivering a common view of
enterprise data.
In Staging Area you are carried out ETL operations as per
your business logic in order to fetch processed information
into data ware house.

What are necessary tasks to install reportnet software?

976

---

What is meta data and system catalog?

2345

---

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

973

---

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1122

---

what are the major three types of modeling used?

1112

---

Why fact table is in a normal form?

1027

---

What is difference macros and prompts?

2383

---

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

1012

---

What is the working process for application.cfm?

1083

---

What is the difference between view filter and report filter?

967

---

What is drilling across?

1045

---

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1042

---

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1109

---

What is the difference between Datawarehouse and OLAP?

970

---

What are the steps involved in designing a fact table?

932

---