Answer Posted / bhaskar.nagi
Star Schema: Star Schema contains Centrally located Fact
table sourended by Dimension Tables. So Data Base design
looks like a Start. Fact table contains the fact information
at the lowest level granularity. Fact table contains Foreign
keys and Dimension Table contains Primary key.
Snow Flake Schema: In a star schema, if a dimension table is
spleted into one or more dimension results in normalization
of dimensions. Since the database design looks like snow
flake structure.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain about scorecarding?
What are the themes in a data warehouse?
Define the cognos reporting tool?
---------------Tell me about DWH Concepts?
Tell me about Dnamic and Static Dashboards?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
Define olap designer?
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.
What do you understand by ‘ibm predictive maintenance and quality’?
What is the difference between the content store and content manager?
What do you understand by the term 'aggregate advisor?'
hi my name is siraj i want to know cognos queriy language
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
What do you understand by the cognos?
