Answer / alhad kulkarni

The question is Advantages and Disadvantages, not What is
Star or Snowflake.
Star Adv: Reduced Joins, Faster Query Operation.
Snow Adv: Distributed data, Easier to obtain fact-less data
e.g. Orders Shipped across one Quarter.

Star DisAdv: Bigger table sizes, Too many rows in Fact Table
Snow DisAdv: More number of joins, Slower Query operation,

Answer / ravi sadanand

Star Schema: It is fully denormalized schema.the diagram of
fact table with dimension tables resembles a star that's
why it is called star schema.All the dimensions will be in
2nd normal form.
Snow flow schema:In this all dimensions will be in
normalized form.that's why it is called normalized star
schema.For each attribut a seperate table will be
created.As there is a possibility for more number of
joins,obviously the performance will be degraded.

Answer / susanta karmakar

Star Schema: A star schema is a specialized design that
consists of multiple dimension tables, which describe
aspects of a business, and one fact table, which contains
the facts about the business.For example, if you have a
mail-order business selling books, some dimension tables are
customers, books, catalogs, and fiscal years. The fact table
contains information about the books that are ordered from
each catalog by each customer during the fiscal year.

Answer / hania

Star Schama : easy for users to understand, optimize navigation and more suitable for query processing, and works faster.

Disadvantages: Dimension table have greater rows, large fact table

Answer / krishna

in starschema the fact is denormalised ...all dimension
tables are normalise..there will be primary foreignkey
relation ship between fact and dimension tables.
for better perfomance we use starschema when compare to
snow flake schema ..where fact table and dimension tables
are normalised...for every dimension table tthere will be a
look table ..we have to dig from top to bottom in the
snowflake schema.

what is junk dimension

4 Answers   Cap Gemini,

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

what is polling?

1 Answers   Informatica,

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

What is the command used to run a batch?

0 Answers  

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

What is the difference between Normal load and Bulk load?

5 Answers  

What is native users?

0 Answers