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 a joiner transformation?

0 Answers  

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

Without source how to insert record to target?

6 Answers  

Explain why we use partitioning the session in informatica?

0 Answers  

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

When the informatica server marks that a batch is failed?

1 Answers  

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

What is a surrogate key?

0 Answers  

Why touse stored procedure in ETL Application?

2 Answers