Answer Posted / rams

Independent Data Mart Dependent Data Mart
1) it won't have 1) it will share the common dimension
shared Dimension
2) perfect Data mart 2) it's a Enterprise DW

What is surrogate key? Explain with examples.

1122

---

Explain what is power center repository?

987

---

What is a source qualifier?

1075

---

What is difference macros and prompts?

2279

---

How to create prompts in report net?

976

---

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

912

---

I need a good brd and uc template?

1065

---

Can a dimension table contain numeric values?

1041

---

Explain the versions of reportnet?

972

---

Explain what does level of granularity of a fact table signify?

942

---

What is fact less fact table? Where you have used it in your project?

979

---

what is parallel query?

2063

---

What are the different types of data warehouses?

1069

---

What are session timeout and application timeout? Where we have to do this process?

1013

---

What are the steps to build the datawarehouse?

1028

---