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
Write types of folders present in cognos?
What are all the types of hierarchies?
Explain difference between powerplay transformer and power play reports?
How the Bursting happens in same report and how to Print the bursting Report?
Explain what is the difference between native sql and cognos sql?
7. What is performance tuning?
What is Metrics designer?
What is the difference b/w macros and prompt?
What is the size of the cube?
What is Bitmap Index?
what are the special features in cognos reportnet?
What are the types of folder present in cognos?
Can you define a datastore in cognos?
What is the difference between a cascading report and drill through report?
What is the use of cognos decision stream?