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

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2354

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6097

What is the purpose of Dataware Control?

1125

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1053

Explain how to generate iqd file from framework manager?

1040