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...


star and snowflake schema?

Answers were Sorted based on User's Feedback



star and snowflake schema?..

Answer / rr

Star schema has denormalised dimension tables connected to
a single fact table.
Snow flake schema has normalised dimension tables.

Is This Answer Correct ?    8 Yes 2 No

star and snowflake schema?..

Answer / sathish

Star Schema

Star Schema is the type of modeling where we follow the
complete de-normalization process.A star schema contains
multiple dimensions which share the same fact table.

Say per example in the sales analysis star schema, the
actual sales goes into fact and the customer, product, date,
sales force information goes as dimensions.

Snowflake Schema

In order to strike a balance between 3rd normal form data
model and star schema, we have snow flake schema which is
more of normalized star schema. Even in snow flake we will
have the fact and dimension only big difference is the
dimension tables are normalized.

Is This Answer Correct ?    2 Yes 0 No

star and snowflake schema?..

Answer / deepa

star schema has fact table in the middle and dimensions
around it which are denormalized.
normalized form of star schema is called snow flake star
schema.

Is This Answer Correct ?    1 Yes 0 No

star and snowflake schema?..

Answer / srikanth nallapati

star schema is a centrelized fact table surrounded by
dimention tables.where dimention tables are denormalized .
here the number of joins are less then the query
performence good.

but in snow flake schema dimention tables are normalized
here we can view lowest level granularity .here the number
of joins are high comparing to snowelake schema then
automatically performence is degread.

Note:performence is depending upon the requirement

Is This Answer Correct ?    1 Yes 0 No

star and snowflake schema?..

Answer / tamilarasan m

Star fact table join with all the dimension tables.All the
dimension tables are denormalized.ain Snowflake dim table
join with another dimension.All the dimension r normalized

Is This Answer Correct ?    0 Yes 0 No

star and snowflake schema?..

Answer / mohammed

Snowflake is an extension of star schema, where star schema
with each dimension is typically stored in one table.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is a joiner transformation?

0 Answers  


what is unit testing?tell me proceedure

0 Answers   L&T, UST,


what is the size of u r source(like file or table)?

0 Answers   HP,


How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,


What is sql query override? When did u use sql query override?

1 Answers   TCS,


Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  


what is surrogate id ?

3 Answers   IBM,


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,


Do you find any difficulty while working with flat files as source and target?

0 Answers  


what is the exact meaning of domain?

3 Answers  


What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,


1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,


Categories