Answer Posted / vams_gk

---------------------------------------------------

confrimed
[sales fact]<.........>[customer fact ]
| |
dimentions x,y,z dimentions a,b,c
-----------------------------------------------------

when u applied join between two fact tables u will get a
confriemd dimention

Explain difference between view and materialized view?

507

---

What are fundamental stages of data warehousing?

540

---

In document how to create metrics?

553

---

Explain a relation schema and a relation?

591

---

What are the steps to build the datawarehouse?

583

---

---

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

504

---

Explain what are components of report studio?

570

---

Explain the difference between dw and bi?

519

---

What are the different models used in cluster analysis?

516

---

How to performance tune reports?

579

---

Ist the schema that a data warehouse system can implements.

497

---

Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

488

---

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

569

---

In microstrategy, how can we direct the sql generated to use a specifc table?

531

---

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

514

---