Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Discuss the advantages & Disadvantages of star & snowflake
schema?

Answers were Sorted based on User's Feedback



Discuss the advantages & Disadvantages of star & snowflake schema?..

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,

Is This Answer Correct ?    78 Yes 1 No

Discuss the advantages & Disadvantages of star & snowflake schema?..

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.

Is This Answer Correct ?    34 Yes 11 No

Discuss the advantages & Disadvantages of star & snowflake schema?..

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.

Is This Answer Correct ?    8 Yes 7 No

Discuss the advantages & Disadvantages of star & snowflake schema?..

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

Is This Answer Correct ?    2 Yes 2 No

Discuss the advantages & Disadvantages of star & snowflake schema?..

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.

Is This Answer Correct ?    18 Yes 28 No

Post New Answer

More Informatica Interview Questions

Explain scd type 3 through mapping.

0 Answers  


suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,


what is index?how it can work in informatica

0 Answers  


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,


What are the advantages of informatica?

0 Answers  


What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  


I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,


tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,


i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,


what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,


how can we use sorter transformation in joins?

5 Answers   IBM,


Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,


Categories