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

What are the join types in joiner transformation?

1 Answers   Informatica,

lookup transformation with screenshots

0 Answers   TCS,

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

How to load a relational source into file taget?

2 Answers  

what is the monster dimension plz give me one example

2 Answers   EDS,

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

What is informatica etl tool?

0 Answers  

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

what is threshold error in informatica?

1 Answers   TCS, Wipro,

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,

For more Informatica Interview Questions Click Here
Categories