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 >> Cognos
  2. Suggest New Category

when can i use the STAR Schema and SNOWFLAKE Scgena

Question Posted / krishna.bdm9

Answers were Sorted based on User's Feedback



when can i use the STAR Schema and SNOWFLAKE Scgena..

Answer / subbu

for huge amount of data snowflake schema is the best.and
for less amount of star schema is better

Is This Answer Correct ?    8 Yes 2 No

when can i use the STAR Schema and SNOWFLAKE Scgena..

Answer / saptashaw

Star is better for performance.
Snowflake happens when one or more dimension tables in the
Star are normalized. This is done when there is sparsity in
the concerned dimensions.

Is This Answer Correct ?    3 Yes 0 No

when can i use the STAR Schema and SNOWFLAKE Scgena..

Answer / satya/gunu(satyabadi)

=>
-Star schema is highly denormalized.
-Snowflake schema is normalized.
=>
-As star schema is denormalized, the size of DWH will be larger than that of Snowflake schema.
=>
-Performance wise, star schema is good.
-But if memory utilization is a major concern,then snow flake schema is better than star schema.
=>.. In addition, Generally in real time, we use Snowflake schema only.

Is This Answer Correct ?    1 Yes 0 No

when can i use the STAR Schema and SNOWFLAKE Scgena..

Answer / khushbu

snowflake is normalized model there for it require less storage space.
but star schema is not normalized. it has redundant data therefore require more storage.

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Cognos Interview Questions

Wht is difference between content store and content manager?

2 Answers   Satyam, Tech Mahindra,

WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?

2 Answers   ABC Infotech, Virtusa,

Explain the different stages in creating a report in cognos report net?

3 Answers   IBM,

----------How to cretae a Template?

4 Answers  

Explain about embedded & standalone filters?difference between them

1 Answers  

pls ans what are the filters we have in framework manager? filters in report studio?

3 Answers   IBM,

Diff b/w Crossproduct and Outerjoin?

0 Answers   IBM, Mind Tree,

what is the difference between group span and level span

1 Answers   Satyam,

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

0 Answers   Mphasis, TCS,

what is online view?

0 Answers   HCL,

please tell me architecture of the cognos8?

4 Answers   IBM, TCS,

what is Galaxy schema??

2 Answers   IBM, iGate, Wipro,

For more Cognos Interview Questions Click Here
Categories