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

What are the data types present in bo?

1043

---

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

942

---

Explain a relation schema and a relation?

1036

---

What are Aggregate tables?

1105

---

Can we start and stop single session in concurent bstch?

888

---

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

981

---

What are fundamental stages of data warehousing?

987

---

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

919

---

What is perform recovery?

997

---

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1018

---

What is freehand sql?

996

---

Whether dimension table can have numeric value?

1054

---

How can you import tables from a database?

1004

---

What is the difference between agglomerative and divisive hierarchical clustering?

1111

---

What is data warehosuing hierarchy?

1053

---