Answer Posted / nrkreddy

snow flake shema is nothing but fact table is sourrended by
dimension table getting the lowest level of the
information

snow flake sehema is used for getting the details From
lowest level of Grunularity

in the sense we will get the data from the detailed level

For example : TIME

a Fact table is associated with TIME Dimension up to month
granulary in the sence this DIM table having

year-->Quater-->month

beut we need the information Up to a day in this senario we
will go Snowflake shema is sliced deeply up to the Day

year-->Quater-->month-->week-->Day

here the dimension table

Why is business intelligence (bi) important in data warehousing?

953

---

Which component has onread method and what it is used for?

992

---

Explain what is the difference between power center & power mart?

1008

---

Explain multivalued dependency?

997

---

if you use oracle sql*loader , how do you transform data with it during loading?

2110

---

What are the different types of data warehousing?

966

---

Do you view contain data?

950

---

What is data analysis?

972

---

Explain dimension table ?

989

---

Briefly state different between data ware house & data mart?

1058

---

Can you state some of the innovations throughout history?

988

---

What is data stream and data adaopter. Is it same are different? Explain?

1024

---

What does level of granularity of a fact table signify?

1101

---

How to import vsam files from source to target. Do we need a special plugin?

941

---

Explain how are the dimension tables designed?

1068

---