Answer Posted / abhinav

data warehouse
1. DW is a collection of information for all enterprise wide.
2. it usually contain the historical data.
3.information for analysis diff. department.but can manipulate/alter the data after authorization permission.
4.store the data for corporate view.

data mart
1. it is a part of the DW.
2. its gives the total information of the particular department.
3. it allow the user to update the data for transactional use.
4. it's mostly used by the department view.

Explain dimension table ?

923

---

What are templates in which way it is help full?

939

---

What are the different types of join operations?

938

---

Explain what are the methodologies of data warehousing?

868

---

How to create context?

955

---

What are Aggregate tables?

1105

---

What is Discrete and Continuous data in Data mining world?

2575

---

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2065

---

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

958

---

What is the difference between olap and datawarehosue?

899

---

What is the difference between view filter and report filter?

879

---

How to create diff. Types of templates?

985

---

How can we schedule the graph in unix?

934

---

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

895

---

Explain difference between snow flake and star schema.

964

---