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

How to implement security measures using repository manager?

0 Answers  

How can we remove the duplicates from flat file source?

0 Answers  

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

What is a joiner transformation and why it is an active one?

0 Answers  

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

What are multi-group transformations?

0 Answers   Informatica,

What are the session parameters?

3 Answers  

Differentiate between Load Manager and DTM?

0 Answers  

For more Informatica Interview Questions Click Here
Categories