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

Tell me about Schemas?

Answer Posted / swan

There are 2 types of schemas
1)star schema
2)snowflake schema

star schema is amiddle of the fact table it connects to the
no.of individual dimention tables.It containd de-normalized
data

snowflake schema is is a set of tables comprised of a
single, central fact table surrounded by normalized
dimension hierarchies. Each dimension level is represented
in a table. Snowflake schema implements dimensional data
structures with fully normalized dimensions. Star schemas
are an alternative to snowflake schema

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.

5188


What do you understand by the term 'aggregate cache'?

920


How we check the errors before running the report?

946


Define metrics studio?

975


difference between impromptu and cognos8

2376


What is the advantage of using shortcuts?

1111


What is the difference between a cascading report and drill through the report?

1113


1. Explain your project.

1974


what is power prompt in cognos ep7series?what is the use of this?

3623


What is the size of the cube?

886


what is model and say about process how to create model and how to test model?

999


How to select multiple values from type-in prompt?

1009


how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

997


How to test a cube?

2127


Can you explain a cognos controller?

962