Answer / pradeeshkumar

OLAP architecture may be
->Generic Two-Level Architecture
->Independent Data Mart
->Dependent Data Mart and ODS
->Logical Data Mart and active Warehouse
->Three-Layer architecture.
For better understanding of these types in detail. please
surf through.

Can you brief about the Data warehouse project you worked on?

0 Answers   Deloitte, TCS,

---

What is called dimensional modelling?

0 Answers  

---

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

0 Answers   IBM,

---

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

0 Answers  

---

What is the difference between static cache and dynamic cache?

0 Answers  

---

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

0 Answers  

---

What is the difference between star and snowflake schemas?

0 Answers  

---

How to create different types of templates?

0 Answers  

---

What is factless fact tables?

0 Answers  

---

What is surrogate key?

5 Answers   IBM, Informatica,

---

What are partition points?

0 Answers  

---

Whether dimension table can have numeric value?

0 Answers  

---