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

when can i use the STAR Schema and SNOWFLAKE Scgena

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Give me any example of semi and non additive measures?

955


Can you define dimension?

1068


9. What was the most complex type of report you dealt with?

2194


Why is auto-regression used in forecasting used on cognos platform?

1006


Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4717


What is dtm?

1151


what is hints in cognos and where we use it.

2445


How create measures and dimensions?

1051


What are the two types of framework manager?

1294


What is model filter?

1183


What are all the components of Report Studio?

1080


what is the difference between list report and crosstab report?

1162


What is the difference between low affinity and high affinity connections?

1005


What is the use of report studio?

1016


Define report item?

1156