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 some methods to apply securities in framework manager model?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What are the types of folder present in cognos?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What are the types of security?
What do you mean by query studio?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
what is the difference between filter and condition?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
4. How many dimensions did you use in your reports?
what is the difference between list report and crosstab report?
Can you explain dynamic query mode?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
Define datastores in cognos?
