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
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.
What do you understand by the term 'aggregate cache'?
How we check the errors before running the report?
Define metrics studio?
difference between impromptu and cognos8
What is the advantage of using shortcuts?
What is the difference between a cascading report and drill through the report?
1. Explain your project.
what is power prompt in cognos ep7series?what is the use of this?
What is the size of the cube?
what is model and say about process how to create model and how to test model?
How to select multiple values from type-in prompt?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
How to test a cube?
Can you explain a cognos controller?