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 call shell scripts from informatica?

0 Answers  

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

How to do unit testing in informatica?

0 Answers  

what is degenerated dimension table with scenario

2 Answers   HCL,

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

Where can we find the throughput option in informatica?

0 Answers  

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

For more Informatica Interview Questions Click Here
Categories