Answer Posted / naidu

ODS DSS
1.it is designed to support 1.it is designed to support
operational monitoring decision making process
2.Data is volatile 2.Data is non-volatli
3.Current data 3.Historical data
4.Detailed data 4.Summary data

What are Non-additive facts?

1169

---

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

1007

---

What is edw?

1200

---

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1107

---

What are the tools available for etl?

976

---

What is an error log table in informatica occurs and how to maintain it in mapping?

968

---

Explain what is a view as it relates to system modeling?

992

---

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

986

---

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

1022

---

What is drilling across?

995

---

Explain the difference between view and materialized view?

948

---

What is perform recovery?

1108

---

Start a batches with in a batch?

977

---

Explain about core dimension,

992

---

List any five applications of data warehouse.

940

---