Answer / Pujit Kumar Jha

"Data warehouse architecture refers to the design and organization of a data warehouse, which includes the physical and logical layout of the data, as well as the processes used for data extraction, transformation, and loading (ETL). Common architectures include star schema, snowflake schema, and fact-constellation schema."

Where the data cube technology is used?

1 Answers  

---

What are the advantages of cold fusion?

1 Answers  

---

Tell me one example for multi valued dimension or bridge table?

2 Answers   Accenture, CMC, IBM, Logica CMG, TCS,

---

What are the steps involved in creating dimensional modeling process?

1 Answers  

---

what are different storage options supported by oracle ?

1 Answers  

---

Explain when do we analyze the tables? How do we do it?

1 Answers  

---

What are the data marts?

1 Answers  

---

Explain what are the basic needs to join two sources in a source qualifier?

1 Answers  

---

Explain why dimenstion tables are denormalized in nature?

1 Answers  

---

i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

1 Answers   Wipro,

---

What is META DATA information in Data warehousing projects?

2 Answers   IBM,

---

What is up date strategy and what are th options for update strategy?

2 Answers  

---