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
Write types of folders present in cognos?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
Define the cognos reporting tool?
what is log in cognos?
What is defined as data mining?
What is the enterprise class platform architecture of cognos 8?
Can you define a catalog and types of catalogs in cognos?
Name the types of report?
What is the information present in the cognos configuration file?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
What is cognos connection?
What is the function of cognos dispatcher?
Can we test the report other than manual testing?
What is a Cube?
What do you mean by drill through report?