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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Is snow flake or star schema used?
If star schema means why?

Question Posted / radhakrishnansk

Answers were Sorted based on User's Feedback



Is snow flake or star schema used? If star schema means why?..

Answer / venkat

In the aboue two (snow flake,star)schemas ,star schema is
best,because star schema is denormalised and star schema is
centrally located Fact table and surrounded by multiple
dimention tables.so fact table size can be calculated based
on the lowest level granularity of the dimentions.

Is This Answer Correct ?    5 Yes 0 No

Is snow flake or star schema used? If star schema means why?..

Answer / koti

star schema is for simple data marts where as snowflake
schema for complexives...

Is This Answer Correct ?    5 Yes 1 No

Is snow flake or star schema used? If star schema means why?..

Answer / senthil

hi
normally people using star schema in data warehousing
because it is de_normalized and easy way to retrieve data
from target and also understanding..
But snow flake is in fully normalized.normally OLTP
we use normalized ..

star schema used in data warehousing ..

Is This Answer Correct ?    2 Yes 0 No

Is snow flake or star schema used? If star schema means why?..

Answer / radhakrishnansk

star schema is used for easy retrieval.
It is in 2nd normal form.
But snow flake is in 3rd normal form it needs more joins for
retrieval.

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Informatica Interview Questions

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,

How to create the source and target database connections in server manager?

0 Answers   Informatica,

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,

Parameter and variable differences

0 Answers  

What is informatica powercenter repository?

0 Answers  

What is a poling?

2 Answers  

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

What is source qualifier?

6 Answers   SDS,

What are the Advantages of de normalized data?

3 Answers  

Which kind of index is preferred in DWH?

3 Answers  

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

For more Informatica Interview Questions Click Here
Categories