Answer / swamy.l.n

1.IN A STAR SCHEMA IF A DENORMALIZE DIMENTION TABLE SPLITED
INTO ONE OR MORE DIMENTION TABLE RESULTS IN THE
NORMALIZATION OF DIMMENTION TABLE.
2.SINCE THE D-BASE DESIGN LOOKS LIKE A SNOW FLAKE
STRUCTURE.IT IS KNOWN AS SNOW-FLAKE(OR)STAR-FLAKE.

Answer / srinivas

Snow flake schema is a database. it is having centrally
located fact table. and the fact table is surronded by
dimension tables the dimension tables are exploded.
it is a normalized schema.

Answer / azhar

snow flake scheama is one of the type of designs present in
database while the other one is the star schema.It is of
normalized form.

Is there any rownum object from which we can do this?

0 Answers  

---

What are components of report studio?

0 Answers  

---

what is hybrid schema

4 Answers   TCS,

---

If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?

1 Answers   CSC,

---

What is the very basic difference between data warehouse and operational databases?

0 Answers  

---

What is cubes?

0 Answers  

---

Compare and contrast aggregates & indexes

0 Answers   IBM, TCS,

---

What is data type of the surrogate key?

0 Answers  

---

What is difference between Business Objects and Hyperion Essbase? Please help me

1 Answers   Cap Gemini, TCS,

---

Is it possible to have more than one row on the same table with the same foreign key?

2 Answers  

---

what are the others of "bad files" and "discard files" when using sql*loader?

0 Answers  

---

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 347 what is hybrid slowly changing dimension?

0 Answers  

---