Interested to Buy Any Domain ? << Click Here >> for more details...
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, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
what are the features in cognos8ui
What are the services provided in cognos 8?
How do you improve the performance of the Cognos Analytics report
Can you define report item?
How to test a cube?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What are the different uses of a repository manager?
What is the difference between Open Connection command ang Open Session Command?
What are query items?
What is Bitmap Index?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What is the metric store database?
What is model?
What errors and types of errors you faced in Cognos ReportNet?
